Thanks a lot Gila.

.. So ultimately I need to wait till it recovers. And time left to recover will be available in Mirror error log is it ?

By the way, a FORCE failover...

Model ?? You should be able to execute from any DB including Model, as system views are automatically inserted in all the databases including users DBs..

..Did someone backup the log and broke the LSN by any chance for the DB that's failing ?

Or..

anyone deleted any of the log backup from the directory ?

As Kevin mentioned,...

..Something came up my mind this morning..

Suppose a transaction was started before the backup process starts, only one transaction for example.

Backup process back up the pages.. transaction is still open..

But...

Please see the below link.

http://www.simple-talk.com/blogs/2009/02/19/why-should-i-rebuild-a-table-after-dropping-or-adding-a-column/

.. Does that mean SQL Server deadlocks are not logged in sql server errorlog always ?

Hey thanks... We get a take off now 🙂

Anyone thinks anything else.. ?

Thanks agaian.

San.

Thank a lot. Much clear now.

I din't know this at all or perhaps I never noticed it as we always go with the default ones.

However I got it right by guessing, this question would not...

.. Thank you Jeff..

Thanks for the quick responses. As I told even I was not clear.

Yes, I know ACID properties. Just confused with the question.

However would it be ideal if I say,...

.. Yes I can view. But what if I want to see it at a later time ?. That's the requirement.

Normally we process from SSMS .

Sometimes we process from a...

... Exactly... I too had same problem sometime back. I was totally lost.

At last I tried to detach the DB. It threw error saying "Cant detach". But when I refreshed...

It...