Monday, March 19, 2012

Database Market SUSPECT

How to recovery
starting up database 'DATA
opening file d:\dados\data\DATA_data.mdf
opening file d:\dados\data\msdblog.ld
opening file d:\dados\data\northwnd.ld
opening file d:\dados\data\pubs_log.ld
opening file d:\dados\data\DATA_log.ld
bypassing recovery for database 'DATA' because it is market SUSPEC
I don't have backup
TanksBelow is a good start:
http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"jcarlos0402" <anonymous@.discussions.microsoft.com> wrote in message
news:4D6E77FE-4189-44C0-9EC2-B6E2C2BA0552@.microsoft.com...
> How to recovery ?
> starting up database 'DATA'
> opening file d:\dados\data\DATA_data.mdf.
> opening file d:\dados\data\msdblog.ldf
> opening file d:\dados\data\northwnd.ldf
> opening file d:\dados\data\pubs_log.ldf
> opening file d:\dados\data\DATA_log.ldf
> bypassing recovery for database 'DATA' because it is market SUSPECT
> I don't have backup.
> Tanks

No comments:

Post a Comment