Viewing 3 posts - 1 through 3 (of 3 total)
quote:Hi, I have too many table's in the NDF file. Is there a faster way to move all the table from NDF...
quote:
December 17, 2002 at 9:53 pm
#444665
quote:No, but you could script the entire db and rerun the script in a new db. Pretty simple.Steve Jonessjones@sqlservercentral.comhttp://www.sqlservercentral.com/columnists/sjones
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
December 17, 2002 at 9:47 pm
#444664
First, move all the objects back to your mdf file group.
Then, use
"ALTER DATABASE REMOVE FILE "
"ALTER DATABASE REMOVE FILE GROUP"
to drop the specified file & the fille group.
December 17, 2002 at 8:48 pm
#444658