Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ubergeek
Starting Member
3 Posts |
 Posted - 2009-06-18 : 04:28:44
|
UPDATE: Sorted it! Right-clicked in SSMS on db and unticked 'Enable this as a primary database in a log shipping configuration' which then returned a strange conversion error  . I quit SSMS then tried it again and it worked  Hi,I'm running the following to try and remove log shipping on a certain database...On the primary server:EXEC master.dbo.sp_delete_log_shipping_primary_secondary@primary_database = N'xx_PRD',@secondary_server = N'svr2\instancename',@secondary_database = N'xx_PRD'GOOn the secondary server:EXEC master.dbo.sp_delete_log_shipping_secondary_database@secondary_database = N'xx_PRD'GOOn the primary server:EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N'xx_PRD';GOI get the following error after running the third script:Msg 32011, Level 16, State 1, Procedure sp_delete_log_shipping_primary_database, Line 51Primary Database xx_PRD has active log shipping secondary database(s). Drop the secondary database(s) first.I thought the second script dropped the secondary database? |
|
|
|
|
|
Remove Log Shipping?