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, whereas STANDBY mode allows read-only access to the secondary

database.

Configuring Log Shipping Using Management Studio

The following steps create a log shipping confi guration using SQL Server Management

Studio:

1. In the Object Explorer on the primary server in SQL Server Management Studio,
   right-click the database that will be log shipped and review the database
   properties.


2. On the Options page, verify that the recovery model is either Full or Bulk-logged
   and not Simple.


3. On the Transaction Log Shipping page, as shown in Figure 26-2, check the box that
   enables log shipping confi guration.

FIGURE 26-2

Enabling the primary database for log shipping.

c26.indd 667c26.indd 667 7/31/2012 9:49:17 AM7/31/2012 9:49:17 AM

http://www.it-ebooks.info