Data Backup and Recovery

Check existence of backup

JohnMitchell

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

JohnMitchell

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

 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public