|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Gotcha's with SQL 7.0 during NT 4.0 to Win2k upgrade
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 |
Gotcha's with SQL 7.0 during NT 4.0 to Win2k upgrade
|
|
| Sandy Wood 2002-11-04, 1:23 pm |
| I'm preparing to upgrade my SQL 7.0 servers from NT 4.0
to Win2k Adv Server and I'm looking for any 'gotcha's'
that anyone has seen. It looks pretty straightforward but
I'm curious what anyone else has seen.
| |
| Keith Kratochvil 2002-11-04, 1:23 pm |
| None that I know of. Just make sure that you know how to use BACKUP and
RESTORE to move your databases! Also, make sure that you can recreate your
jobs. Finally, you might want to look into scripting your (database)
logins.
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;EN-US;q246133
INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE
http://support.microsoft.com/defaul...b;en-us;Q304692
HOW TO: Move Databases Between Computers that are Running SQL Server
http://support.microsoft.com/defaul...b;en-us;Q314546
--
Keith, SQL Server MVP
"Sandy Wood" <sandy.wood@da.ocgov.com> wrote in message
news:686a01c28432$9b909410$3ae
f2ecf@TKMSFTNGXA09...
> I'm preparing to upgrade my SQL 7.0 servers from NT 4.0
> to Win2k Adv Server and I'm looking for any 'gotcha's'
> that anyone has seen. It looks pretty straightforward but
> I'm curious what anyone else has seen.
| |
| Greg Linwood 2002-11-04, 5:23 pm |
| Hi Sandy
Make sure you update your database statistics after you've finished the
upgrade, otherwise sql2k might not work as efficiently as it shoud.
Make sure you've got a full backup before you do the upgrade.
Cheers,
Greg Linwood
Search the Google archive before re-posting:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Sandy Wood" <sandy.wood@da.ocgov.com> wrote in message
news:686a01c28432$9b909410$3ae
f2ecf@TKMSFTNGXA09...
> I'm preparing to upgrade my SQL 7.0 servers from NT 4.0
> to Win2k Adv Server and I'm looking for any 'gotcha's'
> that anyone has seen. It looks pretty straightforward but
> I'm curious what anyone else has seen.
|
|
|
|
|