"Saiyou Anh" <wa***@alexian.net> wrote in message
news:a5**************************@posting.google.c om...
Hi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do I
need to shut down server? (2) after upgrading, is all login and db
user, group information, scheduled Jobs, maintenance paln... still
there? or I have to save the info before upgrading and recreate after
upgrading? (3) any other tips I need to know? I'm doign that for the
first time.
Thanks!
Saiyou
That depends what you mean by 'shut down the server'. From memory, if you
are upgrading the entire installation (ie. including system databases), then
the SQL7 installation will not be available during upgrade. But if you
install SQL2000 on another server, or on the same server as a named
instance, and then upgrade only some of the user databases using the copy
database wizard, the SQL7 installation will continue to be available.
See "Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)" in SQL
2000 Books Online.
Simon