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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Log shipping reset??

Author  Topic 

SQLCode
Posting Yak Master

143 Posts

Posted - 2007-04-23 : 10:38:50
We had an outage on our Production (our source for log-shipping databases). This broke the log shipping. How can I make it work again?
We are not able to see the maintenance job that log shipped and it does not let us create a new one. Speculation is that the maintenance job got deleted whether intentionally or not.

How can we fix this??

TIA.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-23 : 15:22:07
Is maintenance plan for log-shipping still there?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-23 : 16:57:36
I don't understand why an outage at the primary server would cause log shipping to break. What errors did you find that suggested this?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -