数据库置疑的处理方式

use master
    go
    sp_configure 'allow updates',1
    go
    reconfigure with override
    go
    update sysdatabases set status=-32768 where dbid=DB_ID(dtdyrj_Data')
    go
    dbcc rebuild_log(dtdyrj_Data ','D:\Program Files\Microsoft SQL Server\MSSQL\dtdyrj_log.LDF')
    go
    sp_dboption dtdyrj_Data ','dbo use only','false'
    go
    sp_configure 'allow updates',0
    go
    reconfigure with override
    go




大同大洋软件(大同用友软件)  电话：0352-5388430 13994439175