RE: Moving SQL Server 2000 to a new machine
From: Scott Yu (ScottYu_at_discussions.microsoft.com)
Date: 10/28/04
- Next message: Marcos Federicce: "Recovering a DB using sp_attach_db"
- Previous message: djc: "Re: which datatype do use for this?"
- In reply to: dwh2200: "RE: Moving SQL Server 2000 to a new machine"
- Next in thread: Scott Yu: "RE: Moving SQL Server 2000 to a new machine"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 09:49:08 -0700
First of all, I would like to thank you for your response. Here are my
responses to your instructions.
I already setup a new domain on our test network which I will be using for
this purpose. The test network will consist of 5 SQL Servers to mimic my
production SQL Servers. The new servers are partitioned to mirror the old
servers, and I will build the directory structure to mirror the old server as
well. The test network is totally isolated from our current production
network, so I'll be naming the new 2003 servers and SQL Server 2000 like
there old NT4.0 SQL Server 2000 counter part. Once tested and built, I was
going to rename the old servers, disable all it's jobs and services and then
introduce the new servers to the production domain. Does this sound okay so
far?
> 2. When building the new box, only upgrade to SP2 until you've migrated
> your databases. Only AFTER my databases came online would I be continue to
> upgrade to SP3.
#######################################
Microsoft
states(http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp)
"Windows Server 2003 requires SQL Server 2000 Service Pack 3 or later to be
applied". Hmmm~ so I'm not sure if I can install SP2 for SQL Server 2000 on
my Windows 2003 test box. If I can, please explain.
> 3. Once you've got the new server at SQL2K, SP2, and the physical paths to
> your system files match exactly on both servers, you can take both sql
> servers offline, do a flatfile copy of your old master .MDF and .LDF files
> from the old box over the files on your new box (after you've protected them
> by copying them to a safe, unrelated location, please - we're professionals).
#######################################
I have a maintanence job that backup all the system databases and selected
user databases with log files on a daily basis. Instead of detaching the
.MDF and .LDF, I was going to restore it from a current backup. Will this
work as well?
> 6. You'll have to address two issues you create when doing this. One is
> that the master database is out of synch with what should be the default
> instance name (assuming your using default instance names - it's a problem
> regardless). You'll need to run sp_drop_server and sp_add_server (@local =
> 'local') to get the right server listed as the local server (see Books
> Online). You'll also need to update the [originating_server] fiels in the
> sysjobs table in MSDB. Update the field to match the local instance name you
> used with the sp_add_server.
###############################################
Since my test box and SQL Server 2000 will be name the same as there
production counter parts, I should be able to skip step 6 right? If not,
please explain.
> 7. Once your databases (at the very least, the system databases) have come
> online, then I'd backup up everything and complete the upgrade to SP3, and
> backup everything again.
###############################################
Another idea of mine was to install SP3 on my old NT4.0 SQL Server 2000,
backup it and then move it. This way I might be able to over come the
service patch issue? What do you think of the idea? Are there any known
issues installing SQL Server 2000 SP3 running on a NT4.0 SP6 box.
Once again, thank you very much for your assistant. I know I am asking a
lot more questions and so I appreciate your time, knowledge and
professionalism.
Thank you very much.
Wanna be DBA software engineer
Scott Yu
- Next message: Marcos Federicce: "Recovering a DB using sp_attach_db"
- Previous message: djc: "Re: which datatype do use for this?"
- In reply to: dwh2200: "RE: Moving SQL Server 2000 to a new machine"
- Next in thread: Scott Yu: "RE: Moving SQL Server 2000 to a new machine"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
