Maintance job was failed in step2 full backups

Question

Maintance job was failed in step2 full backups

---

subu

Answer 1

What exact error does it throw?

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

The database xxx in warm stand by state

---

subu

Answer 3

proublem with query re-sult set, Property not set correctly, or connect not establised correctly.

---

subu

Answer 4

Uri,

Actually we have configured Database Mirroring and Logshipping

db01-db02-db03 In Db03 we have maintaince paln in subplan we have configured full database backups it was failed due to below reasons please help us.

---

subu

Answer 5

The database xxx in warm stand by state

Hi,

try exclude the database in a warm stand by state from the maintenance plan backups and the job should work.

Answer 6

Hi Team,

Today also i m getting below error:

 The log shipping secondary database IP-0A7653F2."xx" has restore threshold of 45 minutes and is out of sync. No restore was performed for 1385 minutes. Restored latency is 20 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421).  The step failed.

---

subu

Answer 7

Hi Team,

I have checked backup job, copy job, restore job was scheduled every 15mins

but restore job was not working properly. i check in job history. for this how can i work on it.

Please suggest me.

Tx

---

subu