DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 953743 - Last Review: June 10, 2008 - Revision: 1.2

On This Page

INTRODUCTION

This article describes the instructions that you must follow to manually install updates to Microsoft SQL Server 7.0. All updates for SQL Server 7.0 must be installed manually.

MORE INFORMATION

How to apply updates to SQL Server 7.0

Read this article thoroughly before you install any update for SQL Server 7.0.

Important SQL Server 7.0 updates require the installation of SQL Server 7.0 Service Pack 4 (SP4). If you install an update and conditions occur that require the assistance of Microsoft Customer Support Services (CSS), you may be asked to upgrade immediately to SQL Server 7.0 SP4.

For customers who are running SQL Server 7.0 Enterprise Edition with clustering enabled, see the "How to apply updates to SQL Server 7.0 Enterprise Edition with clustering enabled" section. For all other environments, see the "Standard update installation steps" section.

How to apply updates to SQL Server 7.0 Enterprise Edition with clustering enabled

  1. Back up the master databases before you install any updates to SQL Server.

    Note For more information, visit the following Microsoft Web page:
    http://msdn.microsoft.com/en-us/library/bb469765.aspx (http://msdn.microsoft.com/en-us/library/bb469765.aspx)
  2. Make sure that the computer node where SQL Server 7.0 was originally set up controls the SQL Server resources. To do this, check that the computer node where SQL Server 7.0 was originally set up has _VIRTUAL_SERVER_NAME _ environment variable.
  3. On the same computer node, run the Failover Setup Wizard utility to remove the SQL Server virtual server.
  4. Make a backup copy of the files that are listed in the Knowledge Base article that corresponds to the update that you want to apply. These files are found in the \Mssql7\Binn folder or in the folder where you installed the SQL Server 7.0 program files.
  5. Copy the files from the self-extracting executable file that is provided with the update to the \Mssql7\Binn folder.
  6. Run the Failover Setup Wizard utility to create the Virtual SQL Server resources.
  7. In the Windows 2000 Cluster Manager, right-click SQL Server resource group, and then click Bring On- line.

    Note This brings all services online in their order of dependency.
  8. Connect to SQL Server as a member of the System Administrator role or as a system administrator by using SQL Query Analyzer or by using the osql utility (Osql.exe). Then, run any scripts that have been supplied together with the SQL Server 7.0 SP4 update package.
  9. If you encounter a problem with the update, you can roll back to the previous state before the update was applied. Follow step 2 through step 4 to remove the SQL Server virtual server and copy back relevant files. You must restore the master database that you backed up in step 1.

Standard update installation steps

  1. Back up the master databases before you install any updates to SQL Server.

    Note For more information, visit the following Microsoft Web page:
    http://msdn.microsoft.com/en-us/library/bb469765.aspx (http://msdn.microsoft.com/en-us/library/bb469765.aspx)
  2. Install SQL Server 7.0 SP4. Make sure that SQL Server 7.0 SP4 is installed successfully.
  3. Shut down the Microsoft SQL Server service and the SQL Server Agent service.
  4. Make a backup copy of the files that are listed in the Knowledge Base article that corresponds to the update that you want to apply. These files are found in the \Mssql7\Binn directory or in the directory where you installed the SQL Server 7.0 program files.
  5. Copy the files from the self-extracting executable file that is provided with the update to the \Mssql7\Binn directory.
  6. Start the Microsoft SQL Server service and the SQL Server Agent service.
  7. Connect to SQL Server as a member of the System Administrator role or as a system administrator by using SQL Query Analyzer or by using the osql utility. Then, run any scripts that have been supplied together with the SQL Server 7.0 SP4 update package.
  8. If you encounter a problem with the update build, you can roll back to the previous state before the update was applied. Follow step 4 to copy back relevant files. Additionally, you must restore the master database that you backed up in step 1.

REFERENCES

For more information about SQL Server, visit the following Microsoft Web site:
http://www.microsoft.com/sqlserver/2008/en/us/default.aspx (http://www.microsoft.com/sqlserver/2008/en/us/default.aspx)
For more information about how to determine the SQL Server version and edition, click the following article number to view the article in the Microsoft Knowledge Base:
321185  (http://support.microsoft.com/kb/321185/ ) How to identify your SQL Server version and edition
For more information about SQL Server Desktop Engine (MSDE), visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/aa214930(SQL.80).aspx (http://msdn.microsoft.com/en-us/library/aa214930(SQL.80).aspx)

APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 7.0 Service Pack 4
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
Keywords: 
kbinfo kbhowto KB953743
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support