Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Urgent Help Needed Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 2:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
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?
Post #1408238
Posted Thursday, January 17, 2013 3:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
Is the drive size same in Prod and Dev servers?

Please read the BOL section about moving system and user database files.
Post #1408278
Posted Thursday, January 17, 2013 3:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
Thanks Suresh,

Drives are almost same.

The thing is we need to stop the services for moving files right?
Post #1408281
Posted Thursday, January 17, 2013 3:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
-- 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.
Post #1408296
Posted Thursday, January 17, 2013 3:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 6,633, Visits: 14,208
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"
Post #1408297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse