Urgent Help Needed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Urgent Help Needed

Urgent Help Needed

Rate Topic

Display Mode

Topic Options

Author

Message

Ratheesh.K.Nair

Posted Thursday, January 17, 2013 2:25 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,415, Visits: 3,379

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

Suresh B.

Posted Thursday, January 17, 2013 3:25 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 1,075, Visits: 5,119

Is the drive size same in Prod and Dev servers?

Please read the BOL section about moving system and user database files.

Post #1408278

Ratheesh.K.Nair

Posted Thursday, January 17, 2013 3:28 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,415, Visits: 3,379

Thanks Suresh,

Drives are almost same.

The thing is we need to stop the services for moving files right?

Post #1408281

Suresh B.

Posted Thursday, January 17, 2013 3:46 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 1,075, Visits: 5,119

-- 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

Perry Whittle

Posted Thursday, January 17, 2013 3:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 5,204, Visits: 11,158

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" Wink

Post #1408297

« Prev Topic | Next Topic »

Permissions