Backing up SQL NetApp Snapshots using TSM
- by WerkkreW
In our environment we have a 3 node SQL 2005 Cluster which is on NetApp storage. We are currently using SMSQL (NetApp SnapManager for SQL) to take Snapshot backups of the data. This works great, but due to some audit requirements we are also forced to maintain some copies on tape.
We have used NDMP in other places across the enterprise but we do not want to use it in this specific instance.
Basically what I need to do is, get the most recent snapshot copy of the databases on tape, via Tivoli Storage Manager (TSM).
What I have done is, obtained a basic Windows Server 2003 VM with SnapDrive installed, which is SAN attached and zoned to the NetApp, and I have written a batch file to do the following:
Mount the latest __RECENT snapshot lun to the host, using a specific drive letter
Perform a TSM based incremental backup
Dis-mount the LUN
This seems to work fine, except sometimes the LUN's do not mount due to some sort of timeout. Also, due to my limited knowledge of windows batch scripting, I have no way to monitor the success or failure of these backups since I do not know how to send a valid return code back to the TSM scheduling service.
Is there a more efficient/elegant way to accomplish this without NDMP?