November 6, 2012 at 1:08 am
Our sql server databases are being mirrored to another server.
We are also taking regular end of day backups.
Question:
Is it necessary to do backups since mirroring is in place or vice versa?
Thanks
November 6, 2012 at 1:29 am
arkiboys (11/6/2012)
Our sql server databases are being mirrored to another server.We are also taking regular end of day backups.
Question:
Is it necessary to do backups since mirroring is in place or vice versa?
Thanks
Yes, you should always take backups, especially since mirroring requires a full and log backup to initialise to begin with 😉
Mirroring provides availability not recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 9, 2012 at 7:26 am
Mirroring won't protect you from data corruption / loss but backups can.
November 10, 2012 at 2:24 am
I see.
Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply