Robert Davis (9/10/2012)
prettsons (9/9/2012)
First check SQL Server error log ?The error means: You have at least one corrupt page in the database that's being hit during recovery. This means you can't access the database unless you put it in emergency mode (using ALTER DATABASE PIS SET EMERGENCY). You can then poke about an extract data BUT it will be transactionally inconsistent as recovery has not been run. If you don't have any valid backups, or they're too old, the only way to fixup the database is to use emergency mode repair. See Paul blog post at http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/18/636105.aspx
No, it doesn't mean this and telling him to put eh database in emergency mode when it's not suspect is just reckless. Please stop referring to yourself as a recovery expert as you clearly are not.
Dear Robert,
Actually I checked a paul post where the same error mention: ""Database 'xxxxxxxxxxx' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information."
But did not check that "sql-lover" mentioned "The database is not in suspect state". I missed this line. sorry for that. Next time I will carefully suggest any answer!!!
SQL Database Recovery Expert 🙂