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 |
|
loknathmahato
Starting Member
27 Posts |
 Posted - 2012-01-31 : 12:58:20
|
| Hi,I am getting this alerts 2 to 3 times in a day in seconday server."The log shipping secondary database Demo.Demodatabase has restore threshold of 30 minutes and is out of sync. No restore was performed for 31 minutes. Restored latency is 16 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed."can some body help me to know , what exactly the issue?should i increase the restore interval which is actually 15 minuts? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log Shipping restore failed