![]() ![]() sp_delete_log_shipping_primary_database = N'Primary_Database_Name'Īnd below runs on secondary (here also I have changed input parameter)ĮXEC MASTER. I have changed input parameters.ĮXEC MASTER. In the background, it executes stored procedures to remove the metadata from the log shipping related tables in MSDB database.īelow is the sample which runs on primary. Though monotonous, these are painful when the number of databases we are really huge. Have you ever come across a situation where you have large number of databases in log shipping and you have to remove all of them? If you use SQL Server Management Studio, it would take a long time because you have to Right Click on each database, go to properties, choose Transaction Log Shipping tab, choose remove for secondary, uncheck the box and then hit OK.
0 Comments
Leave a Reply. |