How to auto run some script after every restore or backup in Litespeed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Products and Books » Third Party Products » Quest Software » How to auto run some script after every...

How to auto run some script after every restore or backup in Litespeed

Rate Topic

Display Mode

Topic Options

Author

Message

Vladimir Sim

Posted Sunday, January 14, 2007 8:28 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 12, 2009 7:27 PM
Points: 88, Visits: 46

Hi,

If I have some scripts that I need to run after every backup or restore,
is there any automation trigger that I can configure it at LiteSpeed 2005
without having to do it manually ?

Post #336751

Site Owners

Posted Wednesday, January 17, 2007 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Post #337474

Jason Hall

Posted Thursday, January 25, 2007 6:36 AM

Old Hand

Group: General Forum Members
Last Login: Friday, April 29, 2011 1:09 PM
Points: 392, Visits: 81

The easiest way that I can think of to do this would be to create a trigger on the LiteSpeedLocal database on each server that would fire when a backup completes and is successful. The only other way would be to add a step to your backup jobs that runs when successful. I'll keep thinking about this one and will let you know if I can come up with anything else.

Post #339692

« Prev Topic | Next Topic »

Permissions