|
1>sp_configure "allow updates", 1 2>go 1>begin tran 2>go 1> use master 2> go 1>update sysdatabases 2>set status = -32768 3>where name="数据库名" 4>go 如果得到(1 row affected),则 1>commit 2>go 否则 1>rollback 2>go (3)这时重新启动sql server, 再用sa帐号登录到sql server.
1>dump tran 数据库名 with no_log //清除日志 2>go 1>begin tran 2>go 1> use master 2> go 1>update sysdatabases 2>set status=0 3>where name="数据库名" 4>go 如果得到(1 row affected),则 1>commit 2>go 否则 1>rollback 2>go 1>sp_configure "allow updates" ,0 2>go
restart server and check it angain
|