locked
Atualização do SQL Server 2000 RRS feed

  • Pergunta

  •  

    Caros, o banco de dados do SMS está em um SQL 2000 RTM, estou querendo atualizar pro SP4.

    Para atualizar, basta seguir os procedimentos do read-me, ou há algum procedimento extra pelo fato de usar o SMS usar essa base?

     

    Grato.

    terça-feira, 30 de outubro de 2007 12:29

Respostas

  •  

    Daniel,

     

    Segue o passo a passo:

     

    Upgrading SQL Server 2000 to SP4

    What you need to know…

    This is a large upgrade, SP4 is over 170 MB uncompressed! Updates pertain to SQL Server 2000 and MDAC and include bug fixes, enhancement and security updates. Start by downloading and extracting the upgrade to a folder (hint: use a server share if you have multiple servers to update). Once you’ve extracted SP4, find and read the ReadmeSql2k32sp4.htm document included for details on the update process, enhancements and verification of the update.

    To determine the current version of SQL Server, execute one of the following queries against an instance of the database engine by using isql, osql, or Query Analyzer. This is useful both before and after your upgrade to the latest service pack.

    · SELECT SERVERPROPERTY('ProductLevel')
    · SELECT @@VERSION
    · SELECT SERVERPROPERTY('ProductVersion')


    What you need to do…

    1. Backup master, msdb and non system databases (like SMS)

    2. Prior to the actual upgrade stop all SMS services, and all SQL Server services (except mssqlserver).

    3. Recommend creating a cmd file that contains common services that can be stopped. I’ve found that certain error messages can be avoided by stopping ALL unnecessary services.

    4. Sample command file <preSP4Upgrade.cmd>
    REM common items to add, hint: if any of these services are not installed, they are skipped
    net stop SMS_EXECUTIVE
    net stop SMS_SERVER_LOCATOR_POINT
    net stop SMS_SITE_COMPONENT_MANAGER
    net stop SMS_SQL_MONITOR
    net stop SMS_REPORTING_POINT
    net stop "World Wide Web Publishing Service"
    net stop SQLSERVERAGENT
    net stop "Distributed Transaction Coordinator"
    net stop "SMS Agent Host"
    net stop "SMS Remote Control Agent"

    5. Run setup.bat

    6. Follow prompts to install

    7. At the end of setup, decline the restart option

    8. Start SQL Server service (use SQL Server Service Manager)

    9. To upgrade the server system catalog, run the instcat.sql (syntax is contained within the ReadmeSql2k32sp4.htm document referenced earlier)

    10. When complete, restart the server

    11. Verify all services have restarted and SMS services are running properly.

    What you need to check…

    Using one of the version checks referenced earlier, determine the current version of SQL Server:
    e.g. SELECT SERVERPROPERTY('ProductLevel')
    To determine that the system catalog update was successful, from osql or query analyzer:

    sp_server_info 500
    -- result set:
    attribute_value field should = ‘8.00.2039’ – latest version

    Make fresh backups of the system databases (master, msdb) and sms database.

    Boa Sorte

    Claudio Andrade Neto

    quarta-feira, 31 de outubro de 2007 00:06

Todas as Respostas

  •  

    Daniel,

     

    Segue o passo a passo:

     

    Upgrading SQL Server 2000 to SP4

    What you need to know…

    This is a large upgrade, SP4 is over 170 MB uncompressed! Updates pertain to SQL Server 2000 and MDAC and include bug fixes, enhancement and security updates. Start by downloading and extracting the upgrade to a folder (hint: use a server share if you have multiple servers to update). Once you’ve extracted SP4, find and read the ReadmeSql2k32sp4.htm document included for details on the update process, enhancements and verification of the update.

    To determine the current version of SQL Server, execute one of the following queries against an instance of the database engine by using isql, osql, or Query Analyzer. This is useful both before and after your upgrade to the latest service pack.

    · SELECT SERVERPROPERTY('ProductLevel')
    · SELECT @@VERSION
    · SELECT SERVERPROPERTY('ProductVersion')


    What you need to do…

    1. Backup master, msdb and non system databases (like SMS)

    2. Prior to the actual upgrade stop all SMS services, and all SQL Server services (except mssqlserver).

    3. Recommend creating a cmd file that contains common services that can be stopped. I’ve found that certain error messages can be avoided by stopping ALL unnecessary services.

    4. Sample command file <preSP4Upgrade.cmd>
    REM common items to add, hint: if any of these services are not installed, they are skipped
    net stop SMS_EXECUTIVE
    net stop SMS_SERVER_LOCATOR_POINT
    net stop SMS_SITE_COMPONENT_MANAGER
    net stop SMS_SQL_MONITOR
    net stop SMS_REPORTING_POINT
    net stop "World Wide Web Publishing Service"
    net stop SQLSERVERAGENT
    net stop "Distributed Transaction Coordinator"
    net stop "SMS Agent Host"
    net stop "SMS Remote Control Agent"

    5. Run setup.bat

    6. Follow prompts to install

    7. At the end of setup, decline the restart option

    8. Start SQL Server service (use SQL Server Service Manager)

    9. To upgrade the server system catalog, run the instcat.sql (syntax is contained within the ReadmeSql2k32sp4.htm document referenced earlier)

    10. When complete, restart the server

    11. Verify all services have restarted and SMS services are running properly.

    What you need to check…

    Using one of the version checks referenced earlier, determine the current version of SQL Server:
    e.g. SELECT SERVERPROPERTY('ProductLevel')
    To determine that the system catalog update was successful, from osql or query analyzer:

    sp_server_info 500
    -- result set:
    attribute_value field should = ‘8.00.2039’ – latest version

    Make fresh backups of the system databases (master, msdb) and sms database.

    Boa Sorte

    Claudio Andrade Neto

    quarta-feira, 31 de outubro de 2007 00:06
  • Obrigado !

    quarta-feira, 31 de outubro de 2007 10:41