Re: Move Existing SQL Server to a New Server
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/14/04
- Next message: Brannon Jones: "Re: hour separator from . to : ?!?!"
- Previous message: Larry Kippenhan: "Re: To SP, or not to SP..."
- In reply to: MarkS: "Move Existing SQL Server to a New Server"
- Next in thread: MarkS: "Re: Move Existing SQL Server to a New Server"
- Reply: MarkS: "Re: Move Existing SQL Server to a New Server"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 18:41:25 -0600
Mark,
All of what you are attempting to do is doable.
To move the master, you need to use the start up parameters
as outlined in the 224071 article at:
http://support.microsoft.com/?id=224071
You can find the gist of what you need in that article as
well as:
http://support.microsoft.com/?id=314546
http://support.microsoft.com/?id=304692
2. Restore master, then model, then msdb then the user
databases.
3. You can move the data and log files in the process of
restoring or attaching. With the master database, you need
to use the startup parameters. I'm not sure of what you mean
by moving all mdfs and ldfs in "one move"
4. The master database does not need to be on the same
partition as the SQL Server binaries.
5. If you are restoring the original master database, it
will have what it needs when you restore model, msdb and the
user databases. The data elements stored in the master
database would be restored. The other information is stored
in the individual databases.
Mostly, you'd want to really study the above articles and
practice some of the moves, restores somewhere - even if
it's just to your own PC. The articles and steps may not
make much sense if you haven't really practiced the act of
moving or restoring the databases - especially related to
system databases.
You may want to try just restoring the master somewhere.
When you run into problems, make not of the exact error
message and error number. Then post a message on one of the
newsgroups. It's hard to tell what steps you may have missed
or what went wrong without the error messages.
-Sue
On Mon, 13 Sep 2004 12:05:00 -0700, "MarkS"
<marks@mezzetta.com> wrote:
>I am currently running a MS SQL server 2000 on a RAID 5 (3 drives) with a
>simple volume in the OS (Win2K member server) and a C and E partition.
>Everything SQL related is on the E partition.
>
>I plan to move it to a Win2K3 server with SQL 2000 SP3 which has a RAID 1 OS
>and SQL application, another RAID 1 for the logs, and a RAID 0/1 for the
>data. I have assigned C and E partitions to the OS disks with the SQL app
>on E. I have assigned the L to the logs disks, and M to the data disks.
>
>I attempted to RESTORE (with move) the master database first, because I
>could not find any specific guidence on how to proceed. Each time I ran
>into a problem, I found a KB article ( see below) that seemed on point, but
>failed somehow. I changed tacks and attempted a detach/attach strategy, but
>that failed as well.
>
>I dealt with multiple issues over an 11 hour period (a lot of file transfer
>time and restoring back to original configuration). This is a production
>only environment, so I have to work after hours.
>
>Now I went back to square one.
>
>1) What cites are there for best practices on such a move?
>
>2) In what sequence should I transfer databases? (user, master, model,
>msdb)
>
>3) Can I go from having all mdf and ldf files on one partition E to
>multiple partitions (M and L) in one move?
>
>4) Does the master db need to remain on the same partition as the SQL app,
>or can it remain with the other mdf files on M?
>
>5) Would a startup master database acquire all the necessary meta files by
>restoring or attaching the user, msdb, and model databases? What would I
>lose?
>
>Here are the KB articles that I have already worked with: 224071, 304692,
>221465, and 314546.
>
>Thanks in advance.
- Next message: Brannon Jones: "Re: hour separator from . to : ?!?!"
- Previous message: Larry Kippenhan: "Re: To SP, or not to SP..."
- In reply to: MarkS: "Move Existing SQL Server to a New Server"
- Next in thread: MarkS: "Re: Move Existing SQL Server to a New Server"
- Reply: MarkS: "Re: Move Existing SQL Server to a New Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
