|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > upgrading questions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
upgrading questions
|
|
| BriHyn 2002-11-20, 3:23 pm |
| Hopefully this will be an appropriate group for this question, but if
not, I apologize.
As an advance, any course of action will obviously be tested on a
sandbox machine fully before advancing. Now, the question...
We have a NT4.0 box running SQL 7.0. I've been given the go ahead to
upgrade to Win2k/SQL2k.
What course of action is recommended. Whatever I do will take place on
a late friday night/early saturday morning, so the full upgrade will
be done at once.
My assumption is that it would be best to upgrade to Win2k/sp3 first,
followed then by the SQL upgrade? One option was to format the server
and start clean, but I'm guessing that would be the last choice of
action, correct?
Opinions?
Brian Hynes
| |
| Keith Kratochvil 2002-11-20, 3:23 pm |
| I always prefer clean builds over upgrades (especially when the OS is
involved!).
I would
BACKUP your databases
Script out your users
Know what jobs you have
.....make sure that you know how to restore your users, jobs, and
database(s)...
FORMAT c:
install the OS (and patches)
install SQL Server (and service packs)
add the users to the database
restore your databases
add the jobs back
You might find these helpful:
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;EN-US;q246133
http://support.microsoft.com/?kbid=246133
INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE
http://support.microsoft.com/defaul...b;en-us;Q304692
http://support.microsoft.com/?kbid=304692
HOW TO: Move Databases Between Computers that are Running SQL Server
http://support.microsoft.com/defaul...b;en-us;Q314546
http://support.microsoft.com/?kbid=314546
In addition, Books Online has information on BACKUP and RESTORE.
Make sure that you know what you are doing before you blow away your
current server! If you have not used backup/restore before, maybe you can
try it on a test server.
--
Keith, SQL Server MVP
"BriHyn" <lollybri@netscape.net> wrote in message
news:8859c9d5.0211201225.5b031166@posting.google.com...
> Hopefully this will be an appropriate group for this question, but if
> not, I apologize.
> As an advance, any course of action will obviously be tested on a
> sandbox machine fully before advancing. Now, the question...
> We have a NT4.0 box running SQL 7.0. I've been given the go ahead to
> upgrade to Win2k/SQL2k.
> What course of action is recommended. Whatever I do will take place on
> a late friday night/early saturday morning, so the full upgrade will
> be done at once.
> My assumption is that it would be best to upgrade to Win2k/sp3 first,
> followed then by the SQL upgrade? One option was to format the server
> and start clean, but I'm guessing that would be the last choice of
> action, correct?
> Opinions?
> Brian Hynes
|
|
|
|
|