SQL Server 2005日志文件损坏怎么办？

　　在SQL Server 2005的日志文件损坏时，你会发现以下的情况： 华夏网管论坛bbs.ofAdmin.Com

　　◆1、在SQL Server Management Studio中显示数据库处于置疑(suspect)状态。

　　◆2、事件日志可能会出现如下错误信息： 网管网ofAdmin.Com

　　Could not redo log record (21737:686:9), for transaction ID (0:2334886), on page (1:37527), database 'Test' (database ID 15). Page: LSN = (21735:299:5), type = 2. Log: OpCode = 3, context 19, PrevPageLSN: (21737:615:1). Restore from a backup of the database, or repair the database.

网管论坛bbs.ofAdmin.Com

　　During redoing of a logged operation in database 'Test', an error occurred at log record ID (76116:286:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.

Tags：SQL   Server   日志损坏   责任编辑：「在路上」