Hi, we've just mirrored a database and I'm concerned about backing it up incase I stuff up the mirroring, which I think works on moving transaction logs. Will backing up a mirrored database affect the mirroring? Are there any general best practices for backing up mirrored databases? thanks in...

Seems like a confusion in the process, as the databases will be in production why don't you set the database mirroring once they are set on live server and choose the development as mirror using wizards. If you have scripts then it is better to test them before ensuring all are going well. Take a...

Database mirroring transfers transaction log records directly from one server to another and can quickly fail over to the standby server. The transaction log records are placed first in a database's log buffer in memory, and then flushed to disk (or 'hardened') as quickly as possible. In...