SMSQL Backup and mirror or replicated databases

vloiseau — Thu, 05 Jun 2025 07:10:22 GMT

Hi,

I haven't find any documentation about best practice around mirrored or replicated database, if it is possible or not and if anyone hase clearer view from experience :

- Can SMSQL work with mirrored databases ? How we can backup it up ? Does the backup status is mirrored too ? IT seems that the mirror database is in recovering mode and cannot be accessed directly.

- Can SMSQL work with replication like transaction log replication ? Does the log truncation is replicated too ? Or the 2 databases are independant from a backup point of view ?

- In the other replication mode (merge, snapshot) is it possible to work with SMSQL ? It seems that the suscribers database are read-only ?

Mirrorring technology :

http://technet.microsoft.com/en-us/library/cc917680.aspx

Types of replication :

http://technet.microsoft.com/en-us/library/ms152531.aspx

Thanks.

Re: SMSQL Backup and mirror or replicated databases

curtish — Fri, 27 Aug 2010 15:17:45 GMT

Why would you want to back up the mirrored database? Why not backup the primary with SMSQL?

Is the primary on non-NetApp storage?

Thanks,

Tom

topic Re: SMSQL Backup and mirror or replicated databases in ONTAP Discussions

SMSQL Backup and mirror or replicated databases

Re: SMSQL Backup and mirror or replicated databases