--关于SQLServer 2000中错误9003和数据库置疑问题的解决方案
--1.删除日志文件,如果不能删除,运行下面的语句后再删除
--2.运行下面的语句
use master
go
exec sp_configure 'allow updates',1
go
reconfigure with override
go
update sysdatabases set status=-32768 where dbid=DB_ID('ERun_9_SY')
go
alter database ERun_9_SY set single_user with rollback immediate
go
dbcc rebuild_log('ERun_9_SY','E:\E-Run\E9_SY_Server\ERun_9_SY_log.LDF')
go
alter database ERun_9_SY set multi_user
go
|