Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Snap Mgr for SQL breaking log chains Expand / Collapse
Posted Thursday, March 21, 2013 11:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 22, 2016 9:33 AM
Points: 57, Visits: 250
I have inherited a dozen or so servers which have been configured with Snap Manager for SQL backups in addition to traditional SQL backups. Neither backup set is restorable since they are breaking each other's log chains. One server has 6 daily SMSQL backup jobs, but only one appears in the scheduler. I'm assuming the others were configured using powershell or some other non-GUI means.

I would like to disable the jobs I can't see and manage, and let the one job I can actually manage go ahead and run. (we use the product to mount clones for test and dev) I'll then schedule our "traditional" SQL backup job to run immediately after the SMSQL job, thus giving us a clean set of T-Logs. Does anyone have a Powershell script to a) discover the invisible jobs -and- b) delete the invisible jobs? The SMSQL console shows the log reports for the 6 daily backup runs, but only displays one scheduled job.

I'd appreciate any input or assistance you can give me on this.
Post #1433927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse