February 4, 2003 at 9:11 am
Hi I recently found that on one of our servers, SQL server application files and datafiles(i.e for the databases ) are all installed on a drive normally reserved for just application files. This has caused this drive to rapidly fill up. I am now loaded with the Task of sepearing these files out so that the Application ie SQL server files resides on its present drive but all the database files (eg .dbf or .ldf files) be moved to a totally new drive. What is your advice on how to go about his.
February 4, 2003 at 9:19 am
My standard course of action is to back the databases up, and restore with the move option to the new location. This gives me an opportunity to test the backup/restore situation and benchmark the process as well as the intended move. I like things that accomplish more than one goal with a single process.
You could also simply detach them, copy the files to the new location, and re-attach the databases as well. Under this scenario, I would still back up the databases and verify them prior to the move, just to be safe.
February 4, 2003 at 9:20 am
Shutdown application, detach the database, move the database files to new location and re-attach the database.
If you want to move SQL Server system files, you have to uninstall SQL Server and re-install it.
February 6, 2003 at 1:44 am
Thanks for your reply. It is very well appreciated. Can you kindly let me know the easiest and safest to way to detach and attach a database. I have never attempted this procedure and would like to get it right this first time as I am going to be doing this on one of our production servers!!!!!
quote:
Shutdown application, detach the database, move the database files to new location and re-attach the database.If you want to move SQL Server system files, you have to uninstall SQL Server and re-install it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply