SQL Server 2005 – Moving System Databases

I have recently had SQL Server 2005 setup by a web host, however, they kept the system databases on the C: drive, which in my book is a no no.  I am not a DBA so I don’t know everything but my main reasons for moving these databases are:

1) For performance, you want your data(.mdf) and log(.ldf) files on separate drives.
2) Due to limited space on the C: drive, these files need room to grow.  Especially tempdb.
3) Keeping the house clean.  It is nice to have all the server files that need to be backed up in a single spot. (i.e. web site, email, database, etc.)

Moving these databases is not a trivial task.  There does appear to be a little bit of work that could be error prone if done manually.  So, it was very nice to stumble across an article by Vince Iacoboni who describes the process and provides a script to make the change.  The great thing about Vince is he is active in the discussion board regarding his article and script.

Moving the SQL 2005 System Databases

Explore posts in the same categories: SQL Server

Tags:

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: