sql-backup-restore

《sql-backup-restore》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、TheRedGateGuideSQLServerBackupandRestoreShawnMcGeheeISBN:978-1-906434-74-8SQLServerBackupandRestoreByShawnMcGeheeFirstpublishedbySimpleTalkPublishingApril2012CopyrightApril2012ISBN978-1-906434-85-4TherightofShawnMcGeheetobeidentifiedastheauthorofthisworkhasbeenassertedbyhiminaccordancewithth

2、eCopyright,DesignsandPatentsAct1988.Allrightsreserved.Nopartofthispublicationmaybereproduced,storedorintroducedintoaretrievalsystem,ortransmitted,inanyform,orbyanymeans(electronic,mechanical,photocopying,recordingorotherwise)withoutthepriorwrittenconsentofthepublisher.Anypersonwhodoesanyunau

3、thorizedactinrelationtothispublicationmaybeliabletocriminalprosecutionandcivilclaimsfordamages.Thisbookissoldsubjecttotheconditionthatitshallnot,bywayoftradeorotherwise,belent,re-sold,hiredout,orotherwisecirculatedwithoutthepublisher'spriorconsentinanyformotherthanthatinwhichitispublishedand

4、withoutasimilarconditionincludingthisconditionbeingimposedonthesubsequentpublisher.TechnicalReviewbyEricWisdahlCoverImagebyAndyMartinEditedbyTonyDavisTypeset&DesignedbyPeterWoodhouse&GowerAssociatesTableofContentsIntroduction___________________________________________12SoftwareRequirementsan

5、dCodeExamples________________________________18Chapter1:BasicsofBackupandRestore___________________19ComponentsofaSQLServerDatabase___________________________________20Datafiles________________________________________________________20Filegroups_______________________________________________

6、__________22Transactionlog____________________________________________________24SQLServerBackupCategoriesandTypes__________________________________28SQLServerdatabasebackups_________________________________________29SQLServertransactionlogbackups____________________________________32Fileback

7、ups_______________________________________________________36RecoveryModels______________________________________________________39Simple____________________________________________________________41Full______________________________________________