资源描述:
《backup and restore of sql server databases》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、BackupandRestoreofSQLServerDatabasesSQLServer2012BooksOnlineSummary:ThisbookdescribesthebenefitsofbackingupSQLServerdatabases,basicbackupandrestoreterms,andintroducesbackupandrestorestrategiesforSQLServerandsecurityconsiderationsforSQLServerbackupandrestore.Categ
2、ory:ReferenceAppliesto:SQLServer2012Source:SQLServerBooksOnline(linktosourcecontent)E-bookpublicationdate:June2012Copyright©2012byMicrosoftCorporationAllrightsreserved.Nopartofthecontentsofthisbookmaybereproducedortransmittedinanyformorbyanymeanswithoutthewritten
3、permissionofthepublisher.Microsoftandthetrademarkslistedathttp://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspxaretrademarksoftheMicrosoftgroupofcompanies.Allothermarksarepropertyoftheirrespectiveowners.Theexamplecompanies,organiza
4、tions,products,domainnames,emailaddresses,logos,people,places,andeventsdepictedhereinarefictitious.Noassociationwithanyrealcompany,organization,product,domainname,emailaddress,logo,person,place,oreventisintendedorshouldbeinferred.Thisbookexpressestheauthor’sviews
5、andopinions.Theinformationcontainedinthisbookisprovidedwithoutanyexpress,statutory,orimpliedwarranties.Neithertheauthors,MicrosoftCorporation,noritsresellers,ordistributorswillbeheldliableforanydamagescausedorallegedtobecausedeitherdirectlyorindirectlybythisbook.
6、ContentsBackupandRestoreofSQLServerDatabases.....................................................................................................6RecoveryModels.......................................................................................................
7、...................................................13VieworChangetheRecoveryModelofaDatabase..................................................................................16BackupOverview.........................................................................
8、.................................................................................19RestoreandRecoveryOverview..................................................