679
Chapter 26: Log Shipping
26
To modify or remove log shipping, follow these steps:- In the Object Explorer on the primary server in SQL Server Management Studio,
right-click the log shipping database, and look at the database properties. - Under Select a Page, click Transaction Log Shipping page, (refer to Figure 26-8).
- To modify the parameters of the copy or restore jobs on the secondary server, high-
light the secondary server under Secondary Server instances and databases and
click the ellipsis (...). - To add a new secondary server, click Add under Secondary Server Instances and
Databases. Follow steps 9 through 16 in the section “Confi guring Log Shipping
Using Management Studio.” - To remove a secondary server, highlight the secondary server under Secondary
Server Instances and Databases; click Remove. Log shipping can verify if you want
to remove the secondary server, as shown in Figure 26-11. If you are sure, click Yes.
FIGURE 26-11
Removing a secondary server from the log shipping confi guration.c26.indd 679c26.indd 679 7/31/2012 9:49:20 AM7/31/2012 9:49:20 AM
http://www.it-ebooks.info