January 20, 2011 at 3:52 am
I have a database which has 3 filegroups FG1, FG2, FG3 and 3 datafiles ndf1, ndf2, ndf3.
i have a table T1 which is created on the file group FG2.
Now i create another table T2 on FG3 and copy the data in T2 on Filegroup FG3. And then drop table T1 and instead of shrinking my database can i drop the filegroup FG2 and the datafile associated with it i.e ndf2
Is it possible or not?
will the database be ok or it will get corrupted.
NEVER NEVER EVER GIVE UP;-)
January 20, 2011 at 7:02 am
Yes, it's possible. It's actually the right way to go. If you remove all the objects from the filegroup you can drop the file and filegroup without affecting your database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply