SQL Snippets
ITPROSQL-03 : Technical Overview of SQL Server 2005 Scalability Features Part 1
Heres some awesome demos on SQL 2005 and the suite of new High Availability Fearures for your viewing pleasure ....
Demo 1-1 Creating a Database Mirror https://www.microsoft.com/winme/0509/25037/SQL-03_Demo1-1.asx
Demo 1-2 Establishing Database Mirroring https://www.microsoft.com/winme/0509/25037/SQL-03_Demo1-2.asx
Demo 1-3 Accessing Database Mirror after Failure https://www.microsoft.com/winme/0509/25037/SQL-03_Demo1-3.asx
Demo 2-1 Creating a Database Snapshot https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-1.asx
Demo 2-2 Accessing a Database Snapshot https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-2.asx
Demo 2-3 Damaging a Database that has a Database Snapshot https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-3.asx
Demo 2-4 Recovering Data from Database Snapshot https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-4.asx
Demo 2-5 Reverting a Database to a Database Snapshot https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-5.asx
Demo 2-6 Using Snapshots for Reporting https://www.microsoft.com/winme/0509/25037/SQL-03_Demo2-6.asx