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

Snap Mgr for SQL breaking log chains Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 11:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 7, 2014 4:44 PM
Points: 44, Visits: 194
Hello,
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