资源描述:
《MSSQL2000数据库自动备份的几种方法》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、MSSQL2000数据库自动备份的几种方法SeveralmethodsforautomaticbackupoftheMSSQL2000database.TXTAsimpleandpracticalbackupmethod:Toolsintheenterprisemanager,DatabaseMaintenancePlanner,cansetuparegularautomaticbackupplanfortheDatabase・ThebackupplanisrunautomaticallybystartingtheSqlse
2、rverAgent.Thestepsareasfollows:OpentheenterprisemanagerandclicktheMicrosoftSQLServer一>SQLServergroup->intheconsolerootdirectorytoopenyourServerThenclickthetoolinthetopmenu->toselectthedatabasemaintenanceplanner3,thenextstepistochoosetoautomaticallybackupthedata一>ne
3、xtupdatedatatooptimizeinformation,generallydonotchoosehere>checkthedataintegrity,nextisgenerallynottochooseThenextstepistospecifythedatabasemaintenaneeplan,andthedefaultistobackliponeweek,clickthechangeoptiontomakeadailybackup5,thenextsteptospecifythebackupdiskdire
4、ctory,choosethespecifieddirectory,ifyoucancreateanewdirectoryinDsetsuchas:D:databak,thenchoosetousethisdirectoryhere,ifyourdatabaseismorebestchoiceforeachdatabaseestablishedsubdirectories,andthenselectdeletebackupbeforemanydaysago,generallyset4to7days,thisbackupyo
5、urspecificrequirements,thebackupfileextensiondefaultisBAK5,thenextsteptospecifythetransactionlogbackupplan,seeyouneedtodotoselect->nexttogenerateareport,generallydonotchoose->maintenanceplannexthistory,hadbetterusethedefaultoptions一>completednext6,afterthecompletio
6、nofthesystemislikelytoprompttheSqlServerAgentservicedidnotstart,setpointstodeterminethecompleteplanfirst,andthenfindtherightdesktopSqlgreeniconinthestatusbar,doubleclickonthepoint,inchoosetheSqlServerAgentservice,andthenclicktherunarrow,belowtheselectedautomaticall
7、ystartwhenstarttheOSservicesYoucansetupthestartupSQLserverAgent:runtheservices・msc,andsetthesqlserverAgenttostartautomatical1y.Modifythebackupplan:Opentheenterprisemanager,intheconsoleoftherootdirectoryofthePMontheMicrosoftSQLServer->SQLServergroup->double-clicktoo
8、penyourServer>>managementdatabasemaintenanceplanSecond,longdistancebackupRunningenvironmentanalysis:Theexistingtwomachinesareconfiguredasfollows: