Or how about:

ALTER DATABASE db1 WITH NO_WAIT

or

ALTER DATABASE db1 WITH ROLLBACK IMMEDIATE

Are these possible solutions?

Oh, ok. And this is the only way now?

Thank you Gail. So I would essentially have to change the mirror mode to synchronous, break the mirror, bring the mirror database out of recovery, and go from there?

Even without a witness server?

I have tried to failover the database to the mirror, but was blocked by the stuck SPID. Is there any other way to remove this SPID other than SQL...

I have attached the results from sp_who2. The stuck SPID is 99. As you can see, the SPID is being blocked by itself. If there is a...

Thank you very much, Gail!

And by the way, I've learned a lot from reading your blog! Thanks!

Thank you Gail!

Is there a way to monitor the recovery time?

Thank you Gail and Craig!

I have another question. Once I restart SQL service and the mirrored database is in "In Recovery", will mirroring still be in effect? From...

Thank you very much! I will read those articles and hopefully be able to grab your book. 😀

Does anyone happen to have any insight regarding filegroup backups and piecemeal restores? Thank you in advance.

Ohh, ok. I understand. Thank you very much for shedding some light on this subject for me. If, by chance, you happen to have any literature (links,...

Thank you, David!

I understand that all of the categories are important, but is there some sort of "ranking" that I could use as a guideline? In your example, you...

Thank you for your response. By the way, I forgot to mention that the recovery model is Full.

The piecemeal restore can be done using a full backup. This...

Thank you for responding.

To answer your questions, I would like to partition this table because it has over 100 billion records and users do not need to use...