Browse by Tags

Achieving 99.99% Business Continuity with SQL Server tools

Published 6 June 8 2:39 AM | SSQA.net

Within the IT organisations it has been a huge expansion of increased challenges with regard to number of office locations and keep up the data consistent across the Enterprise. Travelling around the globe is a olden day myth and now even by sitting at...

Filed under: business continuity, sql server, high availability, version, 2008, best practice

SQL Server 2005 Database Mirroring - basics and related resources

Published 10 December 7 4:33 AM | SSQA.net

To provide High Availability feature within your database environment you could take advantage of Database Mirroring when using SQL Server 2005. As with all critical databases, minimizing data loss and downtime are of the highest importance. Having "AlwaysOn"...

Filed under: sql server, databases, high availability, database mirroring, tsql, best practice, production, testing

Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment

Published 6 December 7 12:47 PM | SSQA.net

Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...

Filed under: sql server, restore, high availability, backup, disk, recovery, san, best practice, hardware