May 06, 2010

SnapManager for SQL Server - System Databases

Now remember this one folks.
By all means SnapMirror your system databases (except temp obviously, always except temp!!) but you can't just do it in the conventional manner.
Since the system databases have to have ye-olde-ancient streamy backup (to be consistent anyway) you don't get snapshots in the FlexVols that host these databases.
What you do therefore is to SnapMirror the FlexVols where the Snapinfo is. That FlexVol contains all the goodness for you to do the restore.
When you create the SMSQL job and select to update the mirror you will find that SMSQL is bright enough not to try and replicate the snaps from the database FlexVol but will replicate the FlexVol where the Snapinfo resides. It's pretty clever like that.

Cunning really. It's a couple of extra steps but the whole lot can be done through PowerShell so all you have to do is find the script and hit go.

0 comments: