Monday, March 12, 2012

Moving SQL 2005 DB's

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?
Answered under your thread "Clustered SQL 2005 Standard"
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:e0YxF7SHGHA.3728@.tk2msftngp13.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?
>

No comments:

Post a Comment