The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P45: 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. | 202 Chapter 6 Managing High Availability Figure Transaction Log Shipping Page Filled Out If you wish to configure a remote instance to monitor the log shipping then check the Use a monitor server instance check box which is unchecked in Figure and click the Settings button. On the Log Shipping Monitor Settings page that appears select the Instance to Monitor Log Shipping and click OK. For additional redundancy you can ship your logs to several servers by clicking the Add button in the middle of the Log Shipping properties page of the Database Properties as shown in Figure . EXERCISE Setting Up Log Shipping 1. Set up log shipping between two instances of Microsoft SQL Server 2008. 2. You want to ship the logs every 15 minutes and wait at least one hour before restoring them to your backup server. Managing High Availability Chapter 6 203 3. Be sure to review the code by clicking the Script Configuration button so that you are also familiar with the T SQL stored procedures that are used. All this log shipping can be done via T SQL code as well. Before clicking OK you can script out the commands to the clipboard a new file or a new query window. This will produce a several hundred line set of scripts with about 100 lines of T SQL code to be run against each database server involved. There is no quick and easy way to fail over a log shipping database. To fail over the database disable the log shipping jobs on the backup server and the primary server. Copy any uncopied backup files from the backup share to the destination folder on the backup server. Restore these logs to the backup server. If the primary server is still available back up the transaction log and restore it to the backup server. You can then bring the backup database online by either selecting the WITH RECOVERY option when restoring the last transaction log or by running the RESTORE LOG command with the WITH RECOVERY option without specifying a log file to restore as shown here. After you .
