473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

upgrade from SQL 7.0 to 2000

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
Jul 20 '05 #1
2 2106

"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
Jul 20 '05 #2
Saiyou Anh (wa***@alexian.net) writes:
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.


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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kg7poe | last post by:
We have Sqlsvr 6.5 under NT4. We want to upgrade the database to Sqlsvr 2000 under windows 2K. Is there any way we can do this by copying the database to the win2K computer?? At any rate would...
2
by: Matt | last post by:
Hello All I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the server and restored it. I then installed...
2
by: Trevor Hughes | last post by:
Hello All Our organisation has recently upgraded its operating system to Windows 2000. Prior to this I was running Access 2000 databases on NT machines using the Access 2000 Runtime with no...
2
by: DonLi | last post by:
Hi, I have a copy of Access 97 while my client uses Access 2000 which supports Unicode. My client has ordered a copy of Access 2000 upgrade for me, but the middleman, atomicpark.com is totally...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
4
by: Laphan | last post by:
Hi All I know that if SQL 6.5 was on a server and you then install SQL 2000 on it you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I don't have the luxury of this. I have an...
1
by: rdraider | last post by:
Hi, I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to 2000. I am only choosing to update a single database, not system objects. The Upgrade wizard connects to SQL 6.5,...
2
by: KR | last post by:
Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the...
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.