资源描述：
《好详细的sqlsever2000备份方法》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、好详细的sqlsever2000备份方法AgooddetailedSQLsever2000backupmethod・It'snotthatyoudon，tlaugh.Peoplearenotsmart,andtheylearntobebald.Don'tsaymyheartdoesn'tholdmyheart!No,no,no,no,no,no,no,no!Behappywhenyouarealive,becausewewilldielong.Pleasedon，tspeakEnglishinfrontofme,OK?SQLServerdatabasebackupandrest
2、oreAbackupdatabaseOpentheSQLenterprisemanagerandclickMicrosoftSQLServerintheconsolerootdirectoryTheSQLServergroup一>double-clicktoopenyourServer一>double-clicktoopenthedatabasedirectorySelectyourdatabasename(forexample,BBSdatabaseForum)->andthenclickonthetoolinthemenuabove->toselectthebackupda
3、tabase4selectfullbackup,backup,thepurposeofbackuptoifthereisapathtotheoriginalnameandthenameoftheselectedpointtodelete,andthenpointtoadd,ifthereisnopathandnameoftheoriginaldirectlychoosetoadd,andthenspecifythepathandfilename,afteraspecifiedpointtodeterminethereturntothebackupwindow,thenpoint
4、todetermineforbackupSecond,restorethedatabaseOpentheSQLenterprisemanagerandclickMicrosoftSQLServerintheconsolerootdirectoryTheSQLServergroup一>doubleclickonthenewdatabaseiconintheiconbarofyourServer,>,andtakethenameofthenewdatabaseClickonthenewdatabasename(BBSdatabaseForum)->andthenclicktheto
5、olinthemenuabove->toselecttherestoredatabase4,restoreoptioninthepopupwindow,selecttheselectequipmentfromtheequipment>point>pointtoadd->thenchooseyourbackupfilename->addpointstodeterminereturn,afterequipmentbarshouldappearyoujustchoosethedatabasebackupfilename,backupnumberdefaultsto1(ifyoumad
6、emanybackuptothesamefile,youcanclickbackupnumbernexttoviewthecontent,thecheckboxtoselectwasdeterminedafterthelatestbackup)->aboveandthenclicktheoptionsbuttonnexttotheroutineinstallationoftheSQLyou(youcanalsospecifyyourowndirectory),thelogicalnameofthefiledoesnotneedtochange,tothephysicalfile
7、nameaccordingtoyourrecoverymachinedochange,suchasyourSQLdatabaseinD:\ProgramFilesMicrosoftSQLServerMSSQLData,thenaccordingtoyourcatalogonrecoveryofmachinerelatedchangeschanges,andfinallythefilenameofthebestintoyourcurrentdatabasename(suchastheo
