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

MDMP files Expand / Collapse
Author
Message
Posted Thursday, November 1, 2012 5:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
Nope, not for MSDB. Just stop SQL Agent.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1379735
Posted Thursday, November 1, 2012 5:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, Visits: 255
In that case I need not take an outage, it is just the scheduled jobs will get affected during the restoration.
Post #1379747
Posted Friday, November 2, 2012 6:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:32 AM
Points: 1,324, Visits: 2,941
Correct. By stopping SQLAgent service no jobs will run. Then you restore msdb database from a good db backup, then start SQLAgent.

run the CHECK Integrity again to make sure it is good.



Post #1380321
Posted Friday, November 2, 2012 11:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, Visits: 255
Thank you all

I shall restore the database and check.

Will keep posted.

Thanks,
Dev.
Post #1380528
Posted Saturday, November 10, 2012 7:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, Visits: 255
Hi All,

I stopped my SQL server agent job and restored the MSDB from a good backup. I performed DBCC check after the restoration, it returned 0 allocation errors and 0 consistency errors

Thanks a lot for your suggestions and support

Regards,
Dev.
Post #1383412
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse