--日志损坏的数据库恢复
use master
go
ALTER DATABASE testdb SET EMERGENCY;
ALTER DATABASE testdb SET SINGLE_USER;
--日志文件尚存在仅损坏
--DBCC CHECKDB (testdb,REPAIR_ALLOW_DATA_LOSS)
--DBCC CHECKDB (testdb,REPAIR_REBUILD)
--日志文件不存在
ALTER DATABASE testdb REBUILD LOG ON (NAME=testdb_Log,
FILENAME='D:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAtestdb_Log.ldf')
DBCC CHECKDB (testdb)
ALTER DATABASE testdb SET MULTI_USER
USE testdb
GO
select * from dbo.exam
添加新评论0 条评论