Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I stop log shipping for a particular log shipping pair?

April 26, 2017log pair particular shipping

0

0 Posted

How can I stop log shipping for a particular log shipping pair?

1 Answer

0

0 Posted

• Open the SQL Server Enterprise Manager on the primary server. Expand Management, and then click Maintenance Plan. Right-click the Maintenance Plan, and then click Properties. • Click the Log Shipping tab, and then click to select the log shipping pair that you want to remove. • Click the Delete command button to remove this pair from log shipping. If this is the last pair in log shipping, clicking Delete removes log shipping. If you want to continue log shipping to a different server or to a database, click Add. Then, click to select the appropriate server or database to act as the secondary server before you remove the existing log shipping secondary. Q2: Is there a problem with removing log shipping for a database that has special characters in it’s name?