SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:04 PM
| ||||
| ||||
 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      |
|
02-28-2008, 08:04 PM
| |||
| |||
| Re: upgrade from SQL 7.0 to 2000 "Saiyou Anh" <wangc@alexian.net> wrote in message news:a51d3ca7.0402201034.6881b1d6@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 |
|
02-28-2008, 08:04 PM
| ||||
| ||||
| Re: upgrade from SQL 7.0 to 2000 Saiyou Anh (wangc@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, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
Linear Mode
