SQL Agent

Question

Post reply

SQL Agent

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

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

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;-)

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

Bhuvnesh (3/30/2010)
Sp3 would be fine , ignore my previous post

ok.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 3

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.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 4

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;-)

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

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

refer below link .it might help you http://www.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;-)

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 6

Bhuvnesh (3/31/2010)
Sorry i just saw there is no option i ADD REMOVE programs.
refer below link .it might help you http://www.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.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

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;-)

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 8

Did the resource databse ever get updated?

SELECT SERVERPROPERTY('ResourceVersion');

select @@version

Both versions should be identical.