Microsoft® SQL Server® 2012 Bible

667 Chapter 26: Log Shipping 26 transaction logs. NORECOVERY mode does not allow any database access to the sec- ondary database ...

668 Part V: Enterprise Data Management Confi gure the backup settings, as shown in Figure 26-3, by clicking the Backup Setting ...

669 Chapter 26: Log Shipping 26 Enter an amount of time that the server should wait to send an alert if no new transaction log ...

670 Part V: Enterprise Data Management On the secondary database screen, as shown in Figure 26-4, connect to the server that wi ...

671 Chapter 26: Log Shipping 26 destination local folder on the secondary server. This tab also has a setting that enables fi le ...

672 Part V: Enterprise Data Management FIGURE 26-6 Confi guring the restore transaction log job on the secondary server. To use ...

673 Chapter 26: Log Shipping 26 Delaying restores on secondary database can be extremely useful in case there is an unexpected d ...

674 Part V: Enterprise Data Management As noted previously, adding a monitor server is optional. But if you do not add a monitor ...

675 Chapter 26: Log Shipping 26 FIGURE 26-9 Successful completion of Log Shipping Confi guration. Configuring Log Shipping Using ...

676 Part V: Enterprise Data Management ■ (^) msdb.dbo.sp_attach_schedule: Links the restore job to the schedule ■ master.dbo.sp_ ...

677 Chapter 26: Log Shipping 26 ■ (^) On the monitor server: Expand SQL Server Agent and review the Alert job, log shipping pri ...

678 Part V: Enterprise Data Management Another method to monitor log shipping is to directly review the status of the log shippi ...

679 Chapter 26: Log Shipping 26 To modify or remove log shipping, follow these steps: In the Object Explorer on the primary ser ...

680 Part V: Enterprise Data Management When Yes is clicked, log shipping deletes the secondary database entry on the primary ser ...

681 Chapter 26: Log Shipping 26 FIGURE 26-13 Checking if you want to completely remove log shipping. This action deletes all job ...

682 Part V: Enterprise Data Management FIGURE 26-14 Completely removed log shipping confi guration. Switching Roles Log shipping ...

683 Chapter 26: Log Shipping 26 transactions and bring the secondary database up in an online state. If all the transaction log ...

684 Part V: Enterprise Data Management Log shipping is a robust and reliable high-availability, disaster recovery and reporting ...

685 CHAPTER 27 Database Mirroring IN THIS CHAPTER Understanding the Database Mirroring Overview Confi guring Database Mirroring ...

686 Part V: Enterprise Data Management Database mirroring has a log compression feature that is available in SQL Server 2012 Ent ...