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'
GO
On the secondary server:
EXEC master.dbo.sp_delete_log_shipping_secondary_database
@secondary_database = N'xx_PRD'
GO
On the primary server:
EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N'xx_PRD';
GO
I get the following error after running the third script:
Msg 32011, Level 16, State 1, Procedure sp_delete_log_shipping_primary_database, Line 51
Primary 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?