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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-12-05 : 19:54:43
|
| Hi,I have log shipping configured and on the "backup" server someone deleted all the SQL jobs thinking they were on a different system.Being the "backup" server I wasn't performing any backups of it ... not even the system databases. This will change immediately.In the meantime, any ideas how to recreate or recover the log copy and log restore jobs? I really don't want to go throught the entire setup process again because there a a couple of very large databases (over 100gb).Regards,Terry |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-05 : 23:22:42
|
| if you don't have backups then they are gone forever. |
 |
|
|
|
|
|
Deleted SQL Jobs