How to manually install SQL SP4 scripts when only the binaries have been upgraded

  • [アーティクル]

There are times when we see that while installing Service Pack 4 for SQL Server 2000 on standalone or clustered instance, the binaries have been upgraded but somehow SP4 failed to apply the T-SQL upgrade scripts. You can apply below steps to install SQL Server 2000 SP4 scripts on your instance.

  • After the point that the binaries are upgraded on the cluster nodes or the standalone server, you must run the SQL SP4 scripts
  • Close all applications that are accessing SQL Server, including SQL Enterprise Manager
  • Take the SQL Server offline if on a cluster or stop the SQL Service if standalone
  • Make sure from the services panel that the SQL Service is stopped
  • From command prompt goto path \Program Files\Microsoft SQL Server\MSSQL\Binn
  • Use proper path to reach in Named Instance folders
  • Start SQL Server in Single User Mode from command prompt through command sqlservr -T4022 -T4010 -m
  • Check proper command in SQL 2000 BOL if this is named instance, above syntax is for default instance
  • Open the SQL Query Analyzer & connect to the Master database
  • Run below scripts in Master database in exact sequence as they appear below, taking them from the Install folder of SP4 setup directory
      1. sp1_serv_uni.sql
      2. 80sp1-tools.sql
      3. sp2_serv_uni.sql
      4. 80sp2-tools.sql
      5. sp3_serv_uni.sql
      6. 80sp3-tools.sql
      7. replsys.sql
      8. replcom.sql
      9. repltran.sql
      10. replmerg.sql
      11. remove_old_msx_accounts.sql
      12. sp4_serv_uni.sql
      13. 80sp4-tools.sql
  • At this point you would have installed all the script that SP4 setup applies
  • Close the SQL Query Analyzer
  • At the command prompt press [ctrl+c] keys to shutdown the SQL Server
  • Again make sure from the Service panel that the SQL Server Service is stopped
  • Start the SQL Server again from command prompt sqlservr -T4022 -T4010
  • Open the SQL Query Analyzer & connect to the Master database
  • Run the below stored procedure in Master database [provide the previous build of SQL Server, the below example considers SP3 Build 760]
  • EXEC sp_vupgrade_replication @security_mode=1,@ver_old=760
  • Close SQL Query Analyzer
  • At the command prompt press [ctrl+c] keys to shutdown the SQL Server
  • Reboot the server or the nodes if this is cluster