2010-04-26 06:23 PM
I'm having an issue at a customer site, where they are happily running SM-SQL 5 on SQL 2005 with successful backups, verification and mirroring for their DB, Log and SnapInfo LUN. The problem is that they also have their system DBs on a LUN (model, msdb and master) and want to mirror these databases as well. They back up fine, they have a snapmirror relationship and all the other LUNs are mirroring but not this one. There are no errors in the log and SM-SQL seems to think that everything is fine.
Here's the SM-SQL command:
C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe new-backup –svr 'Server1' -d 'Server1', '6', DB1', 'DB2', 'DB3', 'master', 'model', 'msdb' -ver –verInst 'Server1' -mp –mpdir 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint' -RetainBackupDays 2 -lb -bksif -RetainSnapofSnapInfo 8 -trlog -updmir –mgmt daily
My question is; is this expected behaviour, and if not, what can I do to successfully mirror the system DBs?
2010-04-26 06:29 PM
System databases are not backed up in the same way as user databases.
System databases are backed up using stream-based backups and not
SnapShots. These backups are stored in the SnapInfo directory. In your
case the SnapInfo volume is already mirrored, the system database
backups are anyways getting mirrored across. Also note that unless you
intend to rebuild the same exact server and SQL Server instance at the
DR site, system database backups cannot be restored.
2010-04-26 06:33 PM
Thanks for the reply!
So assuming I do plan to rebuild the exact same instance in a DR situation, is there a way to force the system DBs to mirror across (other than setting up a scheduled SnapMirror)?