Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2005-10-17 : 01:00:16
|
| Hi guys, hope you can help me here...Let's say you have a database with only the primary filegroup defined.The drive gets filled up and you can't truncate or archive any of the files there, but you have an extra drive that is not being used yet1. Will adding a filegroup (defined on the extra drive) solve the problem of disk space?2. If we've added the the filegroup, will saving automatically redirect to the new filegroup or do we need to do some "special tweaking"?TIA--------------------keeping it simple... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-17 : 14:53:28
|
| Once you've added the filegroup, you need to redirect objects to it. By default, all objects are created on the primary filegroup.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-17 : 20:55:35
|
--editBOL is my best friend... |
|
|
|
|
|
|
to group files or not?