Method 1:
Follow below steps to stop the Log Shipping in SQL Server 2008:
1) Right click on LogShipping Primary Server Database.
2) Select the Transaction Log shipping option.
3) Click ... option under secondary server instances and databases Restore Tab from the window.
4) Select the General.
5) Uncheck the Enable option.
6) Select the OK button.
Follow below steps to resume the Log Shipping in SQL Server 2008:
1) Right click on LogShipping Primary Server Database.
2) Select the Transaction Log shipping Option.
3) Click ... option under secondary server instances and databases Restore Tab from the window.
4) Selct the General.
5) Check the Enable option.
6) Select the OK button.
Follow below steps to stop the Log Shipping in SQL Server 2008:
1) Right click on LogShipping Primary Server Database.
2) Select the Transaction Log shipping option.
3) Click ... option under secondary server instances and databases Restore Tab from the window.
4) Select the General.
5) Uncheck the Enable option.
6) Select the OK button.
Follow below steps to resume the Log Shipping in SQL Server 2008:
1) Right click on LogShipping Primary Server Database.
2) Select the Transaction Log shipping Option.
3) Click ... option under secondary server instances and databases Restore Tab from the window.
4) Selct the General.
5) Check the Enable option.
6) Select the OK button.
No comments:
Post a Comment