Data Backup and Recovery Discussions

Check existence of backup

JohnMitchell
views-count 1181 Views

Hi

 

I've been a SQL Server DBA for a while, but I'm new to SnapManager.  What I'm trying to do is create an automated system for checking that databases have been backed up (either natively or through SnapManager), and that the backup devices still exist at the time of the checks.  I know how to do this for native backups, but is there a PowerShell (or other) command that will check that the SnapManager backup of a particular database hasn't been deleted between when it was made and when it was checked, please?

 

Thanks

John

1 REPLY 1

Re: Check existence of backup

JohnMitchell
views-count 1182 Views

OK, I think I need to use the Get-Backup cmdlet.  So I type in this...

Get-Backup –Svr MYSERVER -Inst MYSERVER -D MyDB -SnapInfo \\MYSERVER\X$\SnapInfoFolder

 

which gives this result:

Initializing [get-backup]
Connecting to server: [MYSERVER] [processing]
Connecting to server: [MYSERVER] [completed]
Number of Backups = 5.

 

According to the documentation, Get-Backup is supposed to list the backups, not count them.  Have I missed something important?

 

Thanks

John

 

G2 Review Banner
All Community Forums
Public