Microsoft SQL Server, Error: 926 SQL Server DB_SUSPECT solution

Error:

Database 'DBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926).


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476

No se puede abrir la base de datos 'DBName'. Tiene la marca SUSPECT para recuperación. Consulte el registro de errores de SQL Server si desea más información. (Microsoft SQL Server, Error: 926)

Explanation

• The database is marked as suspect because it failed the recovery process that brings a database to a consistent transactional state. This can occur during the following operations:
• Starting up an instance of Microsoft® SQL Server™ 2000 or SQL Server 2005.
• Attaching a database.
• Using the RESTORE database or RESTORE LOG procedures.

Solution:

• Starting up an instance of Microsoft® SQL Server™ 2000.
• Attaching a database. (.mdf y .ldf files in same folder or path)
• Using the RESTORE database or RESTORE LOG procedures

• Abrir Microsoft® SQL Server™ 2000.
• Adjuntar la base de datos (archivos .mdf y .ldf en la misma ruta o carpeta)
• Usar la opción restaurar

Links

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476

https://technet.microsoft.com/en-us/library/aa258745%28v=sql.80%29.aspx