i'm fairly new at this. can someone help.
i inherited a server where people have been throwing datafiles/indexfiles/logfiles all over the place due to space limitations. i've been approved for more space on the server and am trying to reorganize the filesystem. can someone tell me or point me in the right direction...
how to consolidate multiple log files (i understand having more then 1 log file is completely useless)
how to move datafiles to different drives
how to consolidate multiple datafiles... etc.
any help would be greatly appreciated.
Look in Books Online about using [ DBCC SHRINKFILE ], especially with the EMPTYFILE option.
Moving datafiles is as simple as DETACH thedatabase, copy the files to new location, and the ATTACH the database. You can use the GUI in EM/SSMS, or sp_detach_db and sp_attach_db. The database will be 'off line' as long as it takes to copy the files and re-attach.
No comments:
Post a Comment