January 17, 2013 at 2:25 am
Hi Experts,
We are in process of making one of our dev environment same as PROD. In prod we have drives A & B for Data and C for Log but in Dev the config is A & C for data and B for Log. In Dev all the system databases and some user database files resides in C drive.
Can anyone please help me in achieving this?
January 17, 2013 at 3:25 am
Is the drive size same in Prod and Dev servers?
Please read the BOL section about moving system and user database files.
January 17, 2013 at 3:28 am
Thanks Suresh,
Drives are almost same.
The thing is we need to stop the services for moving files right?
January 17, 2013 at 3:46 am
-- Edited ---
To move the system database (master and tempdb), SQL Server service needs to be stopped.
Only for user databases and msdb, taking the database offline is enough.
January 17, 2013 at 3:49 am
Ratheesh.K.Nair (1/17/2013)
The thing is we need to stop the services for moving files right?
No no no, again wait for my article. This is the biggest misconception. You DO NOT have to stop the SQL Server services to move the user database files, Offlining the database will allow you to move the files without SQL Server locking them.
Only the system dbs (master, etc) will require the service offline
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply