Tag Archives: Mirroring

Automating your snapshots

A little while ago I was talking to someone about possibilities of reporting from SQL Server to avoid impacting the production server and the very first thing that sprang to mind was for them to use snapshotting from a mirror. … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , , | 5 Comments

Back to front mirror

SQL Server database mirroring was obviously a great feature first introduced in SQL 2005 and will improve even further in the next big release (Denali) but quite surprising to me is how drastically the order in which the transactions are … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , ,