Check Activity History using PowerShell?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Check Activity History using PowerShell?

Postby RonJohn » Wed Oct 17, 2012 5:34 pm

Hi,

RG Backup 6.4.0.56

Is it possible to use PS to query the success/failure of backups?

If so, what document/manual is this described in?

Thanks,
Ron
RonJohn
 
Posts: 3
Joined: Wed Oct 17, 2012 5:28 pm

Postby Manfred.Castro » Thu Oct 18, 2012 7:33 pm

The activity history in SQL Backup is populated from information found in the MSDB database so you should be able to query the information you are looking for.
http://www.sqlbackuprestore.com/backuprestorehistorytables.htm
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Re:

Postby RonJohn » Thu Oct 18, 2012 9:21 pm

Manfred.Castro wrote:The activity history in SQL Backup is populated from information found in the MSDB database so you should be able to query the information you are looking for.
http://www.sqlbackuprestore.com/backuprestorehistorytables.htm


Thank you! 8)
RonJohn
 
Posts: 3
Joined: Wed Oct 17, 2012 5:28 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 1 guest