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.

2, next appears as shown in Figure 2-14, the selection of Installation Options dialog box. Select the intermediate upgrade option "update,remove,or add components to a existing instance of SQL Server"

3, next appears as shown in Figure 2-15, select the Instance Name dialog box. You do not have to set the default option if you previously installed it.

4, next appear as shown in Figure 2-16, select the Upgrade Action Options dialog box. Select the "Update your existing Installation" option as shown in the figure.

5, next appear as shown in Figure 2-17, select the upgrade SQL Server Data and Tools dialog box. If the database is not large, you can select this option.

6, next appear as shown in Figure 2-18, select SQL Server Authentication Mode dialog box.

7, the next will collect installation information and system information, and appear as shown in Figure 2-12 confirm the Start Copy File dialog box. You can start copying files and upgrading them. Finally, the upgrade completion dialog appears similar to the one shown in Figure 2-13, completing the upgrade operation.