解决SQLServer数据库被标记为_Suspect_的方法.pdfVIP

17 8 Vol . 17 N o. 8 2007 8 COM PUT ER T ECHN OL O GY A N D DEV EL OPM ENT Aug. 2007 SQL Server Suspect 韩 丽, 崔建涛, 朱训林 ( 郑州轻工业学院计算机与通信工程学院, 河南郑州450002) : SQL Server , Susp ect, , 926 S QL Server Suspect, Sybase SQ L Server Microso t SQL Server , : SQ L Server; ; ; Bypass : T P391 : A : 1673- 629X( 2007) 0 8- 00 67- 0 3 The Way to Solve SQL Server Database Marked by Suspect HA N L i, CU I Jiant ao, ZHU Xunlin ( Coll. o Computer and Co mmunication Eng. , Zhengzhou Univ. o Lig ht Industr y, Zhengzhou 450002 , China) Abstract:SQ L server dat abase is alw ay s marked by suspect w hen int errupted irregularly , it makes dat abase inaccessible and brings a sy st em error 926. A w ay t o solve t his problem t hat SQ L Server dat abase is mark ed by Suspectw ill be given and discussed in t his pa per, w hich is reliable and simple to use Sybase SQ L server and M icroso t SQ L server dat abase. T he advant ages o t his method are simple operat ion and good securit y . Key words:S QL server; DT S ; suspect ; Bypass recovery mode 0 SQL Server Sybase 1989 , , Sybase, M icroso t Asht on - T at e SQL Server 2000 SQL Sybase , OS/ 2 SQL S erver S erver 7. 0 , XM L Ashton- Tate , M i HTT P, croso t Sybase , 1993 Window s Window s NT SQL Server 4. 21994 , M icroso t 2000 , 32 [ 1] 64G SQL Server 2000 Sybase , M icroso t Win dow s N T S QL Server , Sybase ( XM L) , U N IX SQL Server , , [ 1] M icroso t SQ L Server 6. 0,