Re: Upgrade server and migration

#1

First off, if you are not too familiar with SQL Server, make sure that you thoroughly understand the steps before doing anything. Do you have anyone on staff that knows about SQL Server? Do you know any contractors that might be able to help for a few hours? This might save lots of difficulty on your end.

Is your current SQL Server running SQL 2k? If so, you have one less "hoop" to jump through.

Does the new server name need to be the same as the current server?
Generally, it is not recommended to install SQL Server on a PDC or a BDC for security and performance reasons.
It sounds like you have NT4 loaded....and want to upgrade to Win2003. Is it not possible to load up the new machine with Windows 2003 and make it a PDC at the same time? You would only have to install an OS once.

Your best bet to move the databases is BACKUP and RESTORE or sp_detach_db and sp_attach_db. These are fully documented within Books Online (within the SQL Server program group) so I am not going to go into detail on usage.

You will want to move your user databases. If you have created jobs within SQL Server, you might want to move msdb, or you can simply recreate them.

The script within this KB will help you in moving your database users: http://support.microsoft.com/default...;EN-US;q246133

The copy database wizard is not available for download -- it is built in to SQL Server. However, I urge you to use BACKUP and RESTORE or sp_detach_db and sp_attach_db.

--
Keith, SQL Server MVP

"Scott Micale" <smicale (AT) micaledot (DOT) com> wrote

Quote:

I just bought a new server that will run SQL 2000 and
replace the one I currently have. I need help on
figuring out how to migrate all my infomation on my SQL
server to the new one. I have set my new server up as a
BDC, loaded NT 4 on it with SP6. My goal is to make the
new server look just like the old one. The current
server is my PDC and when I can get the SQL data off of
the old one I want to take it offline and promote my new
server to the PDC. Once that is done and I have all my
SQL databases on the new one I want to then either
upgrade the OS to Windows 2003 server, change the
computer name to what the old server was called
(NT_SERVER), and then load SQL 2000 or visa versa. I am
not sure how SQL will like me changing the system name if
I do it after it is loaded. If someone can provide me
with steps on how to achieve this it would really help.
I downloaded a MS SQL White Paper on how to get around in
SQL, because I am a beginner when it comes to SQL. If
there are any tools I need please advise, I think I read
that a Copy Data Base Wizard was available, but I
couldn't find it on the site.

Thank You!

#2

Those steps sound like they would work.

Quote:

I am unclear as to moving the user databases if I have created jobs
within SQL. How do I tell if I have?

I don't know what you mean and I don't know what you are asking

--
Keith, SQL Server MVP

"Scott Micale" <smicale (AT) micaledot (DOT) com> wrote

Quote:

Unfortunately we do not have anyone on staff that knows anything about
SQL. I am kind of familar with the program. I can go in an make
backups of databases and I see where you do the restore. I am familiar
with the Query Analyzer as well. My OLD server is running SQL 2000. I
would like the new server name to be the same, just so that on the
client side there is nothing I really need to configure. If it is a
huge problem, then I guess I could make it something different. I do
understand that I will first make the BDC, which is my new server, the
PDC before I upgrade to Win2k3. After that process is done I will then
upgrade to 2003 server and use AD. I was going to backup every database
to the new server drive and then take the old server offline and promote
the new one. Upgrade to Win2k3 and rename the server, then load SQL
2000 and restore the DB's. Are those the proper steps?

I am unclear as to moving the user databases if I have created jobs
within SQL. How do I tell if I have?

Any other suggestions?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#3

Quote:

I am not familiar with SQL User DB's and their jobs.

User databases are anything that you created or that are used by off the shelf applications (like Great Plains).
Jobs are something that you would create on the server. They are global in nature; they are not really tied to a specific database (although they might call a stored procedure or perform an action within a specific database). These jobs are stored within the msdb database. run the following: 'SELECT * FROM msdb..sysjobs' for a listing of jobs that you have on your server. If you have jobs, you might want to script them, or move the msdb database as well.

--
Keith, SQL Server MVP

"Scott Micale" <smicale (AT) micaledot (DOT) com> wrote

Quote:

I am some what familiar with SQL 2000. I can create
backups and do restores ok. I am familiar with the
Queary Analyzer as well. Unfortunately I do not have
anyone I can call on for support. I am the only one that
knows some things about this. My current server is
running SQL 2000. The new server name I would liek to be
the same so that the clients do not see muchg of a
change. I was planning on making backups to the new
server first, then promoting the new server to a PDC.
Then upgrade to windows 2003 server and change my system
name. After that is done, install SQL 2000 and restore
my DB's. When that is done then I need to load Great
Plains and get it running properly. I am not familiar
with SQL User DB's and their jobs. You might have to
fill me in on that. Any other help you can provide would
be great.

Thanks!

-----Original Message-----
First off, if you are not too familiar with SQL Server,
make sure that you thoroughly understand the steps before
doing anything. Do you have anyone on staff that knows
about SQL Server? Do you know any contractors that might
be able to help for a few hours? This might save lots of
difficulty on your end.

Is your current SQL Server running SQL 2k? If so, you
have one less "hoop" to jump through.

Does the new server name need to be the same as the
current server?
Generally, it is not recommended to install SQL Server
on a PDC or a BDC for security and performance reasons.
It sounds like you have NT4 loaded....and want to
upgrade to Win2003. Is it not possible to load up the
new machine with Windows 2003 and make it a PDC at the
same time? You would only have to install an OS once.

Your best bet to move the databases is BACKUP and
RESTORE or sp_detach_db and sp_attach_db. These are
fully documented within Books Online (within the SQL
Server program group) so I am not going to go into detail
on usage.

You will want to move your user databases. If you have
created jobs within SQL Server, you might want to move
msdb, or you can simply recreate them.

The script within this KB will help you in moving your
database users: http://support.microsoft.com/default.aspx?
scid=kb;EN-US;q246133

The copy database wizard is not available for download --
it is built in to SQL Server. However, I urge you to
use BACKUP and RESTORE or sp_detach_db and sp_attach_db.

--
Keith, SQL Server MVP

"Scott Micale" <smicale (AT) micaledot (DOT) com> wrote in message
news:0b9201c34ad2$f5fa6040$a301280a (AT) phx (DOT) gbl...
I just bought a new server that will run SQL 2000 and
replace the one I currently have. I need help on
figuring out how to migrate all my infomation on my
SQL
server to the new one. I have set my new server up as
a
BDC, loaded NT 4 on it with SP6. My goal is to make
the
new server look just like the old one. The current
server is my PDC and when I can get the SQL data off
of
the old one I want to take it offline and promote my
new
server to the PDC. Once that is done and I have all
my
SQL databases on the new one I want to then either
upgrade the OS to Windows 2003 server, change the
computer name to what the old server was called
(NT_SERVER), and then load SQL 2000 or visa versa. I
am
not sure how SQL will like me changing the system name
if
I do it after it is loaded. If someone can provide me
with steps on how to achieve this it would really
help.
I downloaded a MS SQL White Paper on how to get around
in
SQL, because I am a beginner when it comes to SQL. If
there are any tools I need please advise, I think I
read
that a Copy Data Base Wizard was available, but I
couldn't find it on the site.

Thank You!
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Upgrade server and migration

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: Upgrade server and migration - 07-15-2003 , 01:21 PM

Re: Upgrade server and migration - 07-15-2003 , 04:17 PM

Re: Upgrade server and migration - 07-15-2003 , 04:21 PM