Post reply

SQL Agent

  • March 30, 2010 at 5:39 am

    #1142078

    Sp3 would be fine , ignore my previous post

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 30, 2010 at 6:39 am

    #1142129

    Bhuvnesh (3/30/2010)

    Sp3 would be fine , ignore my previous post

    ok.

  • March 31, 2010 at 12:33 am

    #1142858

    Bhuvnesh (3/30/2010)

    Sp3 would be fine , ignore my previous post

    Hi..

    while applying the service pack 3 Notification services got failed.Please let me know how to rollback the service pack.

  • March 31, 2010 at 12:49 am

    #1142865

    Which server it is ? any details from error log ?

    I pray that should not be production server, as far as i think we can roll back SP3 by removing it from ADD REMOVE programs.

    have you restarted the Sql server?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 31, 2010 at 12:56 am

    #1142867

    Sorry i just saw there is no option i ADD REMOVE programs.

    refer below link .it might help you http://qa.sqlservercentral.com/articles/Service+Packs/sp3/138/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 31, 2010 at 4:26 am

    #1142942

    Bhuvnesh (3/31/2010)

    Sorry i just saw there is no option i ADD REMOVE programs.

    refer below link .it might help you http://qa.sqlservercentral.com/articles/Service+Packs/sp3/138/

    Yes Yes there is no such a option in the list. They are telling its not possible since system tables had been updated while applying the service pack.

    One more thing the sql agent error message is coming still.

  • March 31, 2010 at 4:53 am

    #1142954

    sudhakara (3/31/2010)

    One more thing the sql agent error message is coming still.

    what kind of error ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 31, 2010 at 6:24 am

    #1143016

    Did the resource databse ever get updated?

    SELECT SERVERPROPERTY('ResourceVersion');

    select @@version

    Both versions should be identical.

Viewing 8 posts - 16 through 22 (of 22 total)

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