MS SQL Basics Tutorial: Upgrading from SQL Server 7.0

SQL Server upgrades are an irreversible process that will operate on important systems and data files, with greater risk requiring extra care.

Pre-2.3.1 Upgrade preparation work

To be safe before upgrading, you must make sure that the system is back to the state it was in before the upgrade, so you need to do some extra work. The steps are as follows:

1, to ensure that the operating system to meet installation requirements.

2, to ensure that there is enough disk space for software installation, exchange of data.

3. Maintaining an existing database executes the following DBCC commands on each database: DBCC CHECKDB, DBCC NEWALLOC, DBCC CHECKCATALOG.

4. Ensure that SQL Server's open database configuration parameter is greater than or equal to the number of databases already in the server, including the system database (Master Model pubs tempdb). Can be checked and changed through Enterprise Manager or by using system stored procedure sp_configure.

5. Back up all databases, including system databases. If your hard disk space is large enough, it is a good idea to make a backup of the entire SQL Server directory and all of its data and drivers.

6, backup the operating system's registry, used to restore the original SQL Server.

7. Close the database read-only state. You can use Enterprise Manager or system stored procedure sp_dboption to check.

8. Close any SQL Server-related applications.

After you've done this, you can start upgrading SQL Server.

2.3.2 Upgrade SQL Server

As an example of upgrading the SQL Server 7.0 Standard Edition, the upgrade steps are as follows:

1. Run Setup program, select "Install SQL Server Components", "Standard Edition", "Database server-standard Edition" option in the Installer startup screen in turn , click the Next button in the Welcome dialog box, and the Input Installation Computer Name dialog box appears as shown in Figure 2-1.