Remove secondary ndf file?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 08:43:16 -0800

I have inherited a database from a previous dba which, for
some reason has two data files, and two log files. The mdf
file is only small ( 20MB), but the ndf file is 20GB in
size. What I would like to do is to increase the size of
the main file to 30 GB ( this I could do ) and move the
data from the ndf file to the mdf file, and then remove
the ndf file. I would also want to do the same to the log
files.

Could someone point me to the right direction, as I could
not find it in the online book.

Thanks

Alex
 

Relevant Pages

  • Re: Remove secondary ndf file?
    ... I would run dbcc shrink file with the EMPTYFILE option assuming that the mdf ... to remove the unwanted ndf file. ... > some reason has two data files, and two log files. ...
    (microsoft.public.sqlserver.server)
  • Re: Recommendations for where to keep the data and logs
    ... I will make sure the web app and log files are on the same drive and that ... the .mdf (data files) are on the separate drive. ... >> drives. ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb on C drive?
    ... performance from having the tempdb data files, User db data files and Log ... files all on different physical drives or drive arrays. ... While adding more log files to the log drive array decreases the ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)