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

Moving system databases Expand / Collapse
Author
Message
Posted Tuesday, February 05, 2013 3:24 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 219, Visits: 853
Hello.
We currently hold the Master, model and msdb databases on the C drive. This drive is currently configured as RAID 1. It is approx a 180GB disc with approx 70Gb of free space.
I am considering moving the Master db from the c drive onto its own LUN along with the other system databases.
Can anybody offer any advice on wether this is a good idea or is it likely to cause more trouble ? Also I am presuming this type of operation needs to be done out of ours ?
Any advice, links, on how to acomaccomplishse tasks would be appreciated.

Thanks
Steven
Post #1416130
Posted Tuesday, February 05, 2013 3:26 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:28 PM
Points: 20,453, Visits: 14,063
This is considered a best practice - to move system databases off of the c drive. I move all of my system databases to a different volume when possible.

Here is an article on how to do it.
http://msdn.microsoft.com/en-us/library/ms345408(v=sql.105).aspx




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1416131
Posted Saturday, February 09, 2013 1:32 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 219, Visits: 853
thanks very much for this info.
Post #1417987
Posted Saturday, February 09, 2013 12:07 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 5,844, Visits: 12,571
make sure you follow the sql2005 version of those instructions. Its vital you keep the resource database with the master database in SQL2005.

This definitely needs to be done out of hours.


---------------------------------------------------------------------

Post #1418040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse