Monthly Archives: October 2011

FAQs: Database backup and restore for a mirrored database

Recently, I was asked several regarding database backup and restore for a mirrored database; therefore I think I need to write a blog post about them which may help others who has the similar doubts. Q: Can I do database … Continue reading

Posted in Backup, Database Mirroring, Restore | Tagged , , | Leave a comment

Setup Database Mirroring using Windows Authentication (T-SQL)

Generally, database mirroring involves two SQL Server instances, synchronously or asynchronously replicating transaction logs generated on the first server, known as Principal Server, to the second server, known as Mirror server and replay them on the Mirror server; also we … Continue reading

Posted in Database Mirroring | Tagged | 2 Comments