Post reply

SQLServer 2008 R2 SP 2 confusion

  • September 4, 2013 at 1:32 am

    #277645

    We have three node cluster configuration for SQLserver 2008 R2. We are planning to do upgrade SP 2. We realized that when we did the upgrade on Pre Prod environments our eventviewer started to generate spam message

    "[sqagtres] CheckServiceAlive: returning TRUE (success)"

    To overcome that I understand that we need to apply CU 3 after SP2.

    We decided to take the latest CU (CU 7) at that time.

    We tried Cu 7 again on the lower environment than Pre Prod. It started throwing errors on change data capture.

    2013-09-02 02:52:59.16 spid9s DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    2013-09-02 02:52:59.22 spid9s Unable to upgrade database 'Meta__datat_accounts'. Error '22841' was raised: 'Could not upgrade the metadata for database 'Meta__datat_accounts' that is enabled for Change Data Capture. The failure occurred when executing the action 'sp_cdc_create_change_enumeration_functions'. The error returned was 102: 'line 45, state 1, Incorrect syntax near ')'.'. Use the action and error to determine the cause of the failure and resubmit the request.'. Use the reported error to determine the cause of the failure and then execute sys.sp_cdc_vupgrade in the database context to rerun upgrade.

    2013-09-02 02:52:59.22 spid9s sp_vupgrade_replication executed successfully

    2013-09-02 02:52:59.22 spid9s Saving upgrade script status to 'SOFTWARE\Microsoft\MSSQLServer\Replication\Setup'.

    2013-09-02 02:52:59.22 spid9s Saved upgrade script status successfully.

    2013-09-02 02:52:59.23 spid9s Database 'master' is upgrading script 'upgrade_ucp_cmdw_discovery.sql' from level 171053246 to level 171053250.

    I don't see any abnormal activity in the server.

    My question

    1. Will that be a problem in if I upgrade my prod environments?

    2. What happens If I leave the eventvwr been spammed with messages?

    3. When is SP 3 for SQLserver 2008 R2 coming?

    Can you please help me?

    FYI. We tried with CU 8 also same result.

    Thank you.

  • September 4, 2013 at 10:06 pm

    #1647574

    Any one who had applied sp 2 with multiple cluster node?

    I knew its a free service. Can some one please shed some light or direction with SP 2 upgrade.

    Thank you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply