Day: January 1, 2006

SQL Server 2005 – Introduction to Data Availability In this tutorial you will learn about Data Availability in SQL Server 2005 – Failover clustering, Database mirroring, Log shipping, Replication, Introduction to Database Mirroring and advantages of mirroring. SQL Server 2005 introduces several high availability solutions to improve the availability of servers and databases. These solutions mask the effect of hardware or software failure and maintain the availability of applications so that users perceive a minimum of downtime. The options for creating high availability for a server or a database include:… Read More

SQL Server 2005 – Backing up a Database In this tutorial you will learn about Backing up a Database in SQL Server 2005 – Backup and Restore operations, Restoring System Databases, Media Reliability, Using Checksums during backup and Restore and Backup Media mirroring. Backup and Restore operations. A backup is a copy of the data that is maintained for the purpose of restoration at a later date if a requirement arises due system failure. Failures can occur due to media problems, user errors, hardware failures or natural disasters. Backup of… Read More