Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Restoring System Databases Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 9:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Hi,

A Question. AFter the rebuild I'm seeing the output of this following query showing 0, earlier it used to be 1. What is it? Am i supposed to enable anything?

SELECT is_broker_enabled
FROM sys.databases
WHERE name = N'msdb'


Thanks..
Post #1446779
Posted Thursday, April 25, 2013 9:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
You had service broker enabled before, you'll need to re enable it again. Ideally you should restoring your current backups of your system databases to retrieve the previous configuration.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1446780
Posted Friday, April 26, 2013 12:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thats right. I did restore my backups(just master,model and msdb) after the rebuild. Anything else?

What procedure do i need to take to renable it manaully otherwise?

Thanks
Post #1446807
Posted Friday, April 26, 2013 1:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
mJai (4/26/2013)
Anything else?

Yes enable service broker on the database, it's detailed in books online.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1446821
Posted Friday, April 26, 2013 2:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thanks, That aside, is there a way to verify or compare and ensure that both the msdb databases are same. I mean the msdb backup that i had and the one thats currently active on SQL?

Just wanting to ensure that both copies are the same and I have restored the right ones. :)
Post #1446855
Posted Friday, April 26, 2013 10:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
You could check the history tables see if they have recent events logged

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1447100
Posted Wednesday, May 1, 2013 7:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:01 AM
Points: 416, Visits: 1,345
5 stars thread! Full of great information!

This is how something bad, can be turned on something good and useful.
Post #1448411
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse