Moving the SQL 2005 System Tables

19 Jan 2006 7:31 PM

Kevin Antel

2 Questions Actually!

1. I know how to move all the system DB's in 2000, but I am a bit confused
as to how to accomplish this in 2005.

I need to move:

Master
Model
MSDB

I've already moved Temp.

2. Now, there is this other DB, called the resource DB, which they tell you
not to rename or move. The confusing part is that at install, I did not
have an option to specify where I wanted my log files to go, only my DB
files. Did I miss something?

19 Jan 2006 11:25 PM

Gail Erickson [MS]

> 1. I know how to move all the system DB's in 2000, but I am a bit confused
> as to how to accomplish this in 2005.

The steps for moving all the system databases are in Books Online (December
2005 version) in a topic titled 'Moving System Databases'. It sounds like
you don't have the December version. You can download it from here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

> 2. Now, there is this other DB, called the resource DB, which they tell
> you
> not to rename or move.

There are specific steps for moving the Resource database in the Books
Online topic mentioned above,. Note that the Resource database must be
moved to the same location as the master.mdf file. This is discussed in the
topic.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quoteHide quote

"Kevin Antel" <kev***@cqlcorp.com> wrote in message
news:eQe9C9SHGHA.2040@TK2MSFTNGP14.phx.gbl...
>2 Questions Actually!
>
> 1. I know how to move all the system DB's in 2000, but I am a bit confused
> as to how to accomplish this in 2005.
>
> I need to move:
>
> Master
> Model
> MSDB
>
> I've already moved Temp.
>
> 2. Now, there is this other DB, called the resource DB, which they tell
> you
> not to rename or move. The confusing part is that at install, I did not
> have an option to specify where I wanted my log files to go, only my DB
> files. Did I miss something?
>
>
>