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 @ 9:19 AM
Points: 5,950, Visits: 12,812
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 @ 9:19 AM
Points: 5,950, Visits: 12,812
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 @ 9:19 AM
Points: 5,950, Visits: 12,812
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 01, 2013 7:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 302, Visits: 1,067
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