资源描述：
《数据库置疑处理方法（database query processing）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、数据库置疑处理方法（Databasequeryprocessing）1.setthedatabaseintoastateofemergency:Then,intheSQLqueryanalyzer,selectthemasterdatabaseandenterthefollowingstatementtoexecute(onebyone)Sp_configure'allow',1ReconfigurewithoverrideUpdate,sysdatabases,set,status=32768,where,name='hbposv6'2.rebu
2、ildthelogfile(changethepathtoyourdatafilepath)D:MSSQL$PRODDataisthepathtothedatabasefileKMJXC_log2.ldfisanew,nonexistentfilethatwillbecreatedautomaticallywhenthefollowingstatementisexecutedDbccrebuild_log('hbposv6','D:ProgramFilesMicrosoftSQL,ServerMSSQLDatahbposv6_log
3、2.ldf')3.,canceltheemergencymode(onebyone)Update,sysdatabases,set,status=0,where,name='hbposv6'Restore,database,hbposv6,with,recoverySp_configure'allow',0Reconfigurewithoverride4.fromSQLServerSolution1:youcanusethefollowingcodetofixit:USEMASTERGOSP_CONFIGURE,'ALLOW,UPDATES',1R
4、ECONFIGUREWITHOVERRIDEGOUPDATE,SYSDATABASES,SET,STATUS,=32768,WHERE,NAME='msdb'GoSp_dboption,'msdb','single,user','true'GoDBCCCHECKDB('msdb')GoUpdate,sysdatabases,set,status,=28,where,name='msdb'GoSp_configure,'allow,updates',0ReconfigurewithoverrideGoSp_dboption,'msdb','singl
5、e,user','false'GoSolutiontwo:MSDBdatabaseresolutionprocessDifficulty:becausetheMSDBdatabasecannotbedeleted,itwillbecopiedoutofthefile,andthenaddedtothedatabase,butthenewadditionaldatabasecannotbecalledMSDB,thatis,cannotbethesamename,encountereddifficulties.1:firststoptheentire
6、database,thedatabasefilesmsdbdata.mdfandmsdblog.ldfcopypasteittoanotherdirectory.2:theabovedocumentswillbecopiedtoanotherdirectory,thatis,copytwotimes.3:selectthedatabaserightmouse-"alltasks-"additionaldatabasewillcopyabackupfileattachedto,wherethedatabasenameiscalledMSDB1,the
7、userisSAorADMINISTRATOR.4:MSDB1databasebackup,backupintoafile,thenmynameisMSDB.BAK.5:selectthequerydatabaseMSDB,choosetorestorethedatabase,willjustbackupthedatabaseforciblyrestoredtoMSDB.6:problemsolving,MSDBlibraryandnormaluse.Onceyouhavefinished,quicklybackupthedatabaseagain
8、.Ha-ha。Attached:databasequerysolutionThefirsttimeImetadatabas
