The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P47: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 212 Chapter 6 Managing High Availability Test Day Tip The exam loves to use syntax questions with T SQL. This helps gauge if you know the keywords to the commands or if you can get them in the correct order as well. You might see an answer with SET FAILOVER PARTNER and SET PARTNER FAILOVER and be asked which one is correct. There are two ways to manually fail over a database. You can either bring up the database mirroring properties see Figure and click the Fail over button or you can use the ALTER DATABASE command to failover the database as shown here. If the mirror is completely caught up with all the transactions then the database will fail over. If there are transactions missing from the destination then an error will be returned. ALTER DATABASE Mirroring SET PARTNER FAILOVER EXERCISE Working with Database Mirroring 1. Fail over the database using the T SQL command and the Management Studio. 2. Change the Operating Mode from high performance to high safety then fail over the database again. You can also configure the entire database mirroring by using the ALTER DATABASE command. After you back up and restore the database to the backup server as you did earlier run the ALTER DATABASE command with the SET PARTNER TCP 5022 parameter. You can then run the ALTER DATABASE command with the SET WITNESS TCP . corp 5022 parameter. Using the SAFETY switch you can figure if the database mirroring will use High Safety or High Performance options. Exam Warning Ensure that you know both methods to fail over the database. The exams can test you on either the T SQL or the UI so knowing only one is not enough. Managing High Availability Chapter 6 213 When considering database mirroring as an option for your high-availability solution keep in mind that both the primary server and the mirror must be licensed for use. Clustering Windows Clustering via the Microsoft Cluster Service MSCS is one of the most effective ways of setting up a .
