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 |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2012-06-01 : 06:05:40
|
| Hi all,When running the Log Shipping setup wizard to create a test database, the following error appears:14261: "The specified primary_server_name.primary_database_name already exists....Now, I probably caused this error by dropping a Test database or deleting it's associated jobs without first clicking the "remove log shipping" buttonThe MSKB http://support.microsoft.com/kb/298743 suggests :•sp_delete_log_shipping_primary (http://msdn.microsoft.com/en-us/library/aa259637(SQL.80).aspx) : To delete the primary server from the log_shipping_primary table. •sp_delete_log_shipping_plan (http://msdn.microsoft.com/en-us/library/aa933266(SQL.80).aspx) : To delete the log shipping plan.•sp_delete_log_shipping_secondary (http://msdn.microsoft.com/en-us/library/aa933265(SQL.80).aspx) : To remove secondary server from log_shipping_secondaries table.•sp_remove_log_shipping_monitor (http://msdn.microsoft.com/en-us/library/aa238873(SQL.80).aspx) : To delete the log shipping monitor information from the log_shipping_monitor table.However, won't the very first one disrupt log shipping for the remaining PRODUCTION databases? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-06-05 : 17:58:17
|
| Hi Tara, thanks for the reply.I'll check when I'm back at work tomorrow but I remember doing some Select * on those tables and no rows came back containing 'Test', though I did so in EM and it's probably better done in QA. It will be a dire problem when, not if I need to recreate log-shipping for one of the existing shipping pairs, because we have a known issue with one standby DB or other going suspect every week/fortnight. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-06-14 : 10:03:56
|
| Hi Tara, in my case TWO, primary is the monitor (as it was when I got here!) but I ran the following on Primary: DELETE FROM log_shipping_primariesWHERE Primary_database_name = 'Test'DELETE From log_shipping_secondariesWhere secondary_database_name = 'test'And ran (a few or all) of these on Secondary...Select plan_idFrom sysdbmaintplansWhere plan_name = 'Test'--Copy plan number for the database in question--DELETE sysdbmaintplansWHERE Plan_name = 'Test'Delete sysdbmaintplan_jobsWhere plan_ID = 'PastePlan_IDHere'Delete Sysdbmaintplan_databasesWhere database_name = 'YourDBNameHere'And it worked, thank you !! :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Error creating log shipping