database in recovery

database in recovery

If database suddenly went in to in recovery mode, due to less available space for transaction, you can fire below query and bring it live

USE master
GO
ALTER DATABASE pubs
SET QUOTED_IDENTIFIER ON, RECOVERY FULL, MULTI_USER

Simple Recovery
Simple Recovery allows the database to be recovered to the most recent backup.

Full Recovery
Full Recovery allows the database to be recovered to the point of failure.

Bulk-Logged Recovery
Bulk-Logged Recovery allows bulk-logged operations.


Tags:

The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005database in recoveryDatabase mirroring is currently provided for evaluation purposes only and is not to be used in production environments To enable database mirroring for evaluation purposes use trace flag 1400 during startupHTML5 With DataBasebackup sql databaseSql Server MirroringConnection PoolingLinq to SqlASp.net 2.0 step by step Membership Provider MS SQL server 2005 attach databse without ldf fileWhere is my IP location

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.