ݿĳɽģʽ20090207  20:311.ļʱ˵ûδԴôԹ
𰸣20080716  13:56 ʼ -  Ի 
services.msc

ҵserver  
2.

1½һͬݿ⣨ļļ鶼ԭһȻֹͣݿԭļ滻½ݿļݿ⣬ݿⱻΪsuspect

2ݿĳɽģʽ 
sp_configure 'allow ', 1 
reconfigure with override 
update sysdatabases set status = 32768 where name = 'asiaCardWorkstation' 
3LDFļִ 
DBCC REBUILD_LOG ('asiaCardWorkstation','E:\fdzz1204_Log.LDF')
4ָݿģʽ 
update sysdatabases set status = 0 where name = 'asiaCardWorkstation' 
ִ 
restore database asiaCardWorkstation WITH RECOVERY
sp_configure 'allow', 0
reconfigure with override
5ȻDBCC CHECKDB ('asiaCardWorkstation')ûд 
6滹ǲУ԰ݿΪģʽӦÿԿˣڰݵһµݿ⡣


<<¥SQL Server 2000ݿɵĳ÷SQL Server 2005Ҳࡣ

Ȱԭݿݺ󣬰ʽԡ >>


<<2005updateִupdate sysdatabasesʱʾ

Ϣ 259 16״̬ 1 2  
ϵͳĿ¼мϯ>>


2.   ԭʱmdfļôָһ鷳ˡ 
mdfļǵǰݿģôܽңҲʹsp_attach_dbsp_attach_single_file_dbԻָݿ⣬ 
ǻʾϢ 
豸ļ 'C:\Program Files\Microsoft SQL Server\MSSQL\data\test_Log.LDF'  
ѴΪ 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\test_log.LDF' ־ļ 
ǣݿļǴϸƹģôܲңҲ취вͨˡҲõĴϢ 
: Ϣ 1813 16״̬ 2 1 
δܴݿ 'test'CREATE DATABASE ֹ 
豸ļ 'd:\test_log.LDF' 

ôأżǾ˵ָ취 
AʹĬϷʽһָʹõݿ(test)SQL Server Enterprise Manager潨 
Bͣݿ 
Cղɵݿ־ļtest_log.ldfɾҪָݿmdfļǸղɵݿļtest_data.mdf 
Dݿʱῴݿtest״̬ΪɡʱܶԴݿκβ 
EݿֱӲϵͳ˲SQL Server Enterprise ManagerѡݿҼѡԡڡáҳнϵͳĿ¼ֱ޸ġһѡСҲʹʵ֡ 
use master 
go 
sp_configure 'allow updates',1 
go 
reconfigure with override 
go

FtestΪ޸ģʽ 
update sysdatabases set status=-32768 where dbid=DB_ID('test') 
ʱSQL Server Enterprise Manager濴ݿ⴦ڡֻ\\ѻ\ģʽԿݿıǽϵͳ

GִĻָؽݿ־ļ 
dbcc rebuild_log('test','C:\Program Files\Microsoft SQL Server\MSSQL\Data\test_log.ldf') 
ִйУʾϢ 
: Ϣ 5030 16״̬ 1 1 
δݿִиò 
DBCC ִϡ DBCC ˴ϢϵͳԱϵ[brown][/i] 
˵ʹøݿ⣬ղFʹSQL Server Enterprise Managertestϵͳô˳SQL Server Enterprise ManagerͿˡ 
ȷִɵʾӦڣ 
: ݿ 'test' ־ؽʧȥһԡӦ DBCC CHECKDB ֤һԡݿѡҿҪɾ־ļ 
DBCC ִϡ DBCC ˴ϢϵͳԱϵ 
ʱSQL Server Enterprise Managerῴݿ״̬ΪֻDBOʹáʱԷݿûˡ

H֤ݿһԣʡԣ 
dbcc checkdb('test') 
һִн£ 
CHECKDB  0  0 һԴݿ 'test' У 
DBCC ִϡ DBCC ˴ϢϵͳԱϵ

IݿΪ״̬ 
sp_dboption 'test','dbo use only','false' 
ûгôϲھͿʹûָݿ

JһҪEõġϵͳĿ¼ֱ޸ġһָΪƽʱֱӲϵͳһȽΣյ顣ȻǿSQL Server Enterprise ManagerָҲʹ 
sp_configure 'allow updates',0 
go 
reconfigure with override 


 'sysdatabases' Ч
 
