posted on Friday, April 22, 2005 9:42 AM
by
RickH
SQL Server 2005 Roadshow Notes - Part II - NYC
Yesterday, more then 350 people came to the SQL Server Roadshow in NYC. I hadn't been to NYC for about 13 years. The people there were very friendly.
A user had a question about database mirroring that I had encountered before. The question was “Can you perform a Full Backup on a Mirrored Database”. My gut reaction was “No”. So I responded and expressed to him that it was never then intent to allow backups of the mirror. I emailed a colleague to confirm this. I was correct and told him that I had confirmed it. He then asked another question... It was “If I turn mirroring off, can I backup the database on the mirror”. This is the “Break the Mirror and Backup” strategy. I will be researching this issue to answer in another blog.
BTW - I will be doing a webcast on Mirroring and Snapshots on Tuesday. Check it out at www.unisys.com.