If a the set server appears the breakdown of Raid, pass by hard, basic instauration of data successful, but among them of a Sql Server daily record document( the file extension LDF) damage is seriously, basic can't use, the data document damage is not serious, we make all Recoveries of data through an operation of underneath.

Set up lately first a together the database of, then stop the sql server service, the data document that uses the original database overlays this lately- set up database document, the heavy qi sql server service.Open the business enterprise management machine, that database manifestation" doubt", in search analyze machine the performance language sentence of underneath:

USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
The UPDATE SYSDATABASES SET STATUS= the 32768 WHERE NAME=' the database that doubt'
Go
Sp_dboption' the database that doubt',' the single user',' true'
Go
The DBCC CHECKDB(' the database that doubt')
Go
The update sysdatabases set status= the 28 where name=' the database that doubt'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
Sp_dboption' the database that doubt',' the single user',' false' Go

The database still has problems after the performance, still showing to" query".Set up a new database lately at this time, circulate the DTS to lead a guide, duct into the data in the database that have problems to the new database, open the new database, all of the data find back!