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 |
|
Sirrombor
Starting Member
12 Posts |
 Posted - 2003-10-20 : 10:50:22
|
| Hello,I used Enterprise Manager to configure log shipping to another server. It works great however, lastnight my backup server's motherboard fried.I need to remove log shipping from the Maint Plans on my primary SQL server to point to another machine for shipping, but when I select the configured Maint Plan and go to click remove log shipping I get an error since it can't locate the fried computer that I have log shipping configured too.What do I do? I want to remove these plans/log shipping and just reconfigure it to use another server.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-20 : 12:16:13
|
| Have you looked at the log shipping system stored procedures? Those will do the trick. They are located in the msdb database.Tara |
 |
|
|
Sirrombor
Starting Member
12 Posts |
Posted - 2003-10-20 : 12:51:24
|
| Hi Tara, thanks for your response....I see many Stored Procedures related to log shipping but I am a novice when I have to do anything outside of using Enterprise Mgr. I would be affraid to even attempt changing or running those since I don't know what I am doing or what I am supposed to do.I am considering building a new machine with the same name/IP as the fried system... I am hoping that then I can use Enterprise Mgr. to delete and reconfigure the Log shipping maint plans. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-20 : 12:54:35
|
| I think that you will still be unable to delete log shipping using EM becuase it needs to connect to the msdb database on the destination server and delete the appropriate rows from the log shipping tables in the msdb database.Another way to manually delete log shipping is to delete the related rows in the log shipping tables in the msdb database. These tables start with log_shipping. There are only 5 tables that you need to delete from. You can delete all rows from these tables if you don't have any other databases being log shipped. BTW, these are the table that the log shipping system stored procedures delete from. Just be careful to only delete rows from tables beginning with log_shipping.Tara |
|
|
|
Sirrombor
Starting Member
12 Posts |
Posted - 2003-10-20 : 13:02:20
|
| I will give that I try... I presume that I can always backup and restore the MSDB database if it doesn't work for me...Thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-20 : 13:03:08
|
| Yep.Tara |
|
|
|
Sirrombor
Starting Member
12 Posts |
Posted - 2003-10-20 : 13:18:35
|
| Thanks again Tara.... I manually deleted the rows from the log_shipping tables and it worked =) |
|
|
|
|
|
|
Remove Log Shipping.. How when 2nd machine is gone