upgrade from SQL 7.0 to 2000

[Saiyou Anh]

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

[Simon Hayes]

Re: upgrade from SQL 7.0 to 2000


"Saiyou Anh" <wangc@alexian. net> wrote in message
news:a51d3ca7.0 402201034.6881b 1d6@posting.goo gle.com...[color=blue]
> 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[/color]

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

[Erland Sommarskog]

Re: upgrade from SQL 7.0 to 2000

Saiyou Anh (wangc@alexian. net) writes:[color=blue]
> 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.[/color]

Don't think I have run an upgrade from SQL 7 to SQL 2000, but I would
expect that the upgrade will tell if you need to stop or start the
server prior to installation. My guess is that the installation will
stop and start at will.

I would expect jobs, users etc to be retained.

There is a section in Books Online for SQL 2000 "Upgrading from SQL Server
7.0 to SQL Server 2000". It may the answers you are looking for.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp