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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Merging NDF files

Author  Topic 

GomezJnr
Starting Member

1 Post

Posted - 2005-02-16 : 04:11:28
I have one MDF and several NDF files for a large database that was moved to a new server and would like to know if there is any way to merge these NDF files into one NDF file.

iyerganapas
Starting Member

4 Posts

Posted - 2005-02-16 : 04:54:37
How these ndf files are spread. I mean file groups.
I these ndf files in same File Group, you merge content of all file into a single NDF file. Use dbcc shrinkfile's Emptyfile clause.
Go to Top of Page
   

- Advertisement -