Redirectionserver2008

server2008  时间:2021-01-12  阅读:()
ProSQLServer2008MirroringRobertL.
Davis,KenSimmonsProSQLServer2008MirroringCopyright2009byRobertL.
Davis,KenSimmonsAllrightsreserved.
Nopartofthisworkmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,includingphotocopying,recording,orbyanyinformationstorageorretrievalsystem,withoutthepriorwrittenpermissionofthecopyrightownerandthepublisher.
ISBN-13(pbk):978-1-4302-2423-5ISBN-13(electronic):978-1-4302-2424-2PrintedandboundintheUnitedStatesofAmerica987654321Trademarkednamesmayappearinthisbook.
Ratherthanuseatrademarksymbolwitheveryoccurrenceofatrademarkedname,weusethenamesonlyinaneditorialfashionandtothebenefitofthetrademarkowner,withnointentionofinfringementofthetrademark.
LeadEditor:JonathanGennickTechnicalReviewer:GlennBerryEditorialBoard:ClayAndres,SteveAnglin,MarkBeckner,EwanBuckingham,TonyCampbell,GaryCornell,JonathanGennick,JonathanHassell,MichelleLowman,MatthewMoodie,JeffreyPepper,FrankPohlmann,DouglasPundick,BenRenow-Clarke,DominicShakeshaft,MattWade,TomWelshProjectManager:KylieJohnstonCopyEditor:HastingsHartCompositor:MarySudulIndexer:JulieGradyArtist:AprilMilneDistributedtothebooktradeworldwidebySpringer-VerlagNewYork,Inc.
,233SpringStreet,6thFloor,NewYork,NY10013.
Phone1-800-SPRINGER,fax201-348-4505,e-mailorders-ny@springer-sbm.
com,orvisithttp://www.
springeronline.
com.
Forinformationontranslations,pleasecontactApressdirectlyat233SpringStreet,NewYork,NY10013.
E-mailinfo@apress.
com,orvisithttp://www.
apress.
com.
ApressandfriendsofEDbooksmaybepurchasedinbulkforacademic,corporate,orpromotionaluse.
eBookversionsandlicensesarealsoavailableformosttitles.
Formoreinformation,referenceourSpecialBulkSales–eBookLicensingwebpageathttp://www.
apress.
com/info/bulksales.
Theinformationinthisbookisdistributedonan"asis"basis,withoutwarranty.
Althougheveryprecautionhasbeentakeninthepreparationofthiswork,neithertheauthor(s)norApressshallhaveanyliabilitytoanypersonorentitywithrespecttoanylossordamagecausedorallegedtobecauseddirectlyorindirectlybytheinformationcontainedinthiswork.
Thesourcecodeforthisbookisavailabletoreadersathttp://www.
apress.
com.
CONTENTSiiiContentsataGlanceContents.
ivAbouttheAuthorsxiiAbouttheTechnicalReviewerxiiiIntroduction.
xivChapter1:HighAvailabilityOptions.
1Chapter2:DatabaseMirroringOverview.
11Chapter3:PlanningandBestPractices.
23Chapter4:DatabaseMirroringSetup31Chapter5:AutomatingSetup.
53Chapter6:MaintenanceSimplified.
95Chapter7:MonitoringandAlerting143Chapter8:UpgradingtoSQLServer2008.
171Chapter9:ReportingConsiderations.
189Chapter10:PlanningforFailure209Index227CONTENTSivContentsContentsataGlance.
iiiContents.
ivAbouttheAuthors.
xiiAbouttheTechnicalReviewer.
xiiiIntroduction.
xivChapter1:HighAvailabilityOptions.
1HighAvailabilityvs.
DisasterRecovery.
1DatabaseMirroring.
2FailoverClustering.
2LogShipping.
4Replication.
6ComparingHigh-AvailabilityFeatures7DesigningaCompleteHigh-AvailabilitySolution.
8Summary10Chapter2:DatabaseMirroringOverview11DefiningKeyTerms.
11ChoosinganOperatingMode.
12High-SafetyMode.
14High-PerformanceMode15UnderstandingSessions.
17PausingandResumingSessions.
17CONTENTSvRunningMultipleSessions17UnderstandingMirroringStates.
18SwitchingRoles.
20TransparentClientRedirection.
20EnhancedFeatures.
20LogStreamCompression20AutomaticPageRecovery.
21AvailabilityEnhancements21FeaturesbyEdition.
22Summary22Chapter3:PlanningandBestPractices23StepOne:KnowYourEnvironment.
23AreYourServersReady23IsYourDatabaseReady24DoYouKnowYourServiceAccounts24DoYouKnowYourDatabaseSize25IsYourMirrorComparabletoYourPrincipal25AreYouCombiningwithOtherTechniques25StepTwo:KnowYourApplications.
25HowAreYourApplicationsConnectingtotheServers26DoAnyComponentsNotSupportAutomaticFailover26DoYourApplicationsHaveDependenciesonOtherDatabases26DoYourApplicationsRelyonExternalResources27StepThree:KnowYourPlan27SamplePlan.
27BestPractices.
28Summary30CONTENTSviChapter4:DatabaseMirroringSetup31BeforeYouBegin31PartOne:AdvancedPreparation.
31PartTwo:Pre-setupConfiguration32FollowingtheWizard33SettingUpMirroringManually.
43Step1:CreateEndpoints.
44Step2:CreateLogins45Step3:GrantConnectonEndpointtoLogins.
45Step4:SetthePrincipalPartneronMirror45Step5:SettheMirrorPartneronPrincipal.
46Step6:SettheWitnessPartneronPrincipal.
46Step7:ChangetheOperatingMode.
47SpecialCase:MirroringwithCertificates47Step1:CreateDatabaseMasterKey.
47Step2:CreateaCertificate48Step3:CreateanEndpoint.
48Step4:BackUptheCertificate.
48Step5:CreateLogins49Step6:CreateUsers.
49Step7:AssigntheCertificate.
49Step8:GrantConnectonEndpointtoLogins.
49Step9:ConfigureDatabaseMirroring.
49Test,Monitor,andWrapUp.
49TroubleshootingCommonSetupIssues50RestoreIssues.
50TransactionLogIssues.
51CommunicationIssues51CONTENTSviiSummary52Chapter5:AutomatingSetup.
53PreparetheDatabaseforMirroring.
53BackUpthePrincipalDatabase55RestoreFullBackupontheMirrorDatabasewithNoRecovery.
60BackUptheLogofthePrincipalDatabase.
64RestoretheLogontheMirrorDatabasewithNoRecovery.
64CreateEndpointsonInstances65CreateLoginfortheServiceAccountsandGrantConnect.
67SettheMirroringandWitnessPartners.
69ChangetheOperatingModeIfNotUsingaWitness.
72HelperProceduretoManageLinkedServers.
73TheMasterProcedure74Parameters.
74SampleExecution.
75TheCode.
75AlternativeSetupUsingPowerShell82ThePowerShellSetupScript.
83Summary94Chapter6:MaintenanceSimplified.
95RoutineMaintenanceConsiderations.
95TransactionLogBackups95BackingUptheLogFile.
96WritetheScript.
96MaketheScriptUsable97AutomatingLogBackups.
99ManagingLogBackupRetention.
106CONTENTSviiiDeletingLogBackups.
107LogFileSize110IdentifyingLogFilestoShrink.
111ShrinkingaLogFile.
111RoutinePatchingandSQLServerUpgrades.
115InstallingGeneralPatches.
116UpgradingorPatchingSQLServer.
116FailBacktotheOriginalPrincipal.
117ReasonstoFailBacktotheOriginal.
117ProceduretoFailBacktotheOriginalPrincipal.
118SettingDatabaseOwnerandTRUSTWORTHYProperty.
119ControlledFailoverofMirroredDatabases121ProblemsYouMightEncounter121ProceduretoPerformaControlledFailover121AutomaticFailoverofMirroredDatabases129CreatingaSQLAlerttoDetectAutomaticFailovers130UsingServiceBrokertoDetectAutomaticFailovers.
133StoredProceduretoRespondtoaFailover.
135ServiceBrokerQueue.
138ServiceBrokerServiceandRoute.
139Summary141Chapter7:MonitoringandAlerting143MonitoringComponents.
143DatabaseMirroringStatusTable.
143DatabaseMirroringMonitorJob.
144UnderstandingWarningThresholds.
145UsingtheDatabaseMirroringMonitor.
146RegisteringMirroredDatabases.
146CONTENTSixPerformingHealthChecks.
148ManagingWarningThresholds.
150UsingSystemStoredProcedures152Monitoring152ManagingWarningThresholds.
154UnderstandingPerformanceCounters.
157ConfiguringDatabaseMail159CreatinganOperator161EnablingSQLServerAgentNotifications.
161CreatingAlerts.
162WarningThresholds.
162PerformanceEvents166UsefulViews168UsingtheStateChangeTraceEvent169Summary170Chapter8:UpgradingtoSQLServer2008171UsingtheUpgradeAdvisor171UpgradeStrategies.
180PerforminganIn-PlaceUpgrade181ConsiderationsPriortoPerforminganUpgrade.
181UpgradingHigh-PerformanceMode.
182UpgradingHigh-SafetyModeWithoutaWitness.
182UpgradingHigh-SafetyModewithaWitness.
183MinimizingtheDowntimeofaSide-by-SideUpgrade.
184Post-UpgradeProcedures.
185ChangingCompatibilityLevel185CheckingObjectIntegrity186CorrectRowandPageCounts.
186CONTENTSxSettingthePageVerificationMethod.
186UpdatingStatistics187Summary187Chapter9:ReportingConsiderations.
189UsingDatabaseSnapshots.
189CreatingaDatabaseSnapshot190WorkingwithDatabaseSnapshots.
191DroppingaSnapshot.
193RollingSnapshots.
193UsingLogShipping.
195ImplementingLogShippingwithDatabaseMirroring.
196ConfiguringLogShippingforReporting199UsingReplication.
199TypeofReplicationDatabasetoUse.
200UnderstandingtheTerminology200DesignConsiderations.
200ImplementingReplicationwithDatabaseMirroring.
201Summary207Chapter10:PlanningforFailure.
209DetectingErrors.
209SoftErrors209HardErrors210Non-FailoverErrors211FailoverTime.
211FailureScenarios.
211Scenario1:PrincipalServerUnavailable.
212Scenario2:WitnessServerUnavailable.
212Scenario3:MirrorServerUnavailable.
213CONTENTSxiScenario4:MirrorServerandWitnessServerUnavailable.
214Scenario5:PrincipalServerandWitnessServerUnavailable.
215ProceduretoDropMirroringSessions.
216FailoverConsiderations220ProceduretoCopyLoginsandRoles.
220PlanningandResearch.
223SQLServerWebSites.
223WhitePapers224Webcasts.
224Podcasts.
225FreeTrainingEvents.
225MicrosoftSupportOptions.
225Summary226Index.
227CONTENTSxiiAbouttheAuthorsKenSimmonsisadatabaseadministratoranddeveloperspecializinginSQLServerand.
NET.
Heisaco-authorofProSQLServer2008Administration(Apress,2009).
HehasbeenworkingintheITindustrysince2000andcurrentlyholdscertificationsforMCP,MCAD,MCSD,MCDBA,andMCTSforSQL2005.
KenisactiveintheonlinecommunityandoftenparticipatesintheSQLforumsonMSDNandSQLServerCentral.
com.
HeenjoyssharingtipsbywritingarticlesforSQLServerCentral.
comandMSSQLTips.
com.
Whenheisnotworking,KenenjoystravelingwithhiswifeSusanandsonNathan,andhecanoftenbefoundonacruiseship,ataDisneyresort,oratthebeachinhishometownofPensacola,Florida.
RobertL.
DavisisadatabaseadministratoranddataarchitectconsultingatMicrosoftwhohasworkedextensivelyinsettingupandcreatingautomatedprocessestomanagedatabasemirroringformanyinternalMicrosoftapplications.
HeadditionallyconsultswithvariousinternalMicrosoftITgroupstoassistthemwiththeirdatabasemirroringneeds.
RobertiscurrentlyworkingontheArchitecture&PerformanceEngineeringteamoftheCAPapplicationprogramgroup.
CAPistheinternalsoftwareusedbysupportpersonnelforallofMicrosoft'scustomer-facingproductssuchasXbox,Zune,MSN,WindowsLive,andHotmail.
HehasovereightyearsofSQLServeradministrationexperience,muchofthatinhigh-availabilityenvironments.
Robwritesfrequentlyaboutmirroringandrelatedtopicsinhisblogathttp://www.
sqlservercentral.
com/blogs/robert_davis/default.
aspx.
CONTENTSxiiiAbouttheTechnicalReviewerGlennBerryworksasaDatabaseArchitectatNewsGatorTechnologiesinDenver,CO.
HeisaSQLServerMVP,andhehasawholecollectionofMicrosoftcertifications,includingMCITP,MCDBA,MCSE,MCSD,MCAD,andMCTS,whichprovesthathelikestotaketests.
HeisalsoanAdjunctFacultymemberatUniversityofDenverUniversityCollege,wherehehasbeenteachingsince2000.
CONTENTSxivIntroductionProSQLServer2008Mirroringisyourcompleteguidetoplanning,using,deploying,andmaintainingdatabasemirroringasahigh-availabilityoption.
Mirroringprotectsyoubymaintainingoneormoreduplicatecopiesofyourdatabaseforuseintheeventtheprimarycopyisdamaged.
Itisakeycomponentofanyproduction-level,high-availabilitysolution.
Thisbookcoversthefullspectrumofdatabasemirroring,takingyoufromtheplanningphasethroughtheimplementationtothemaintenancephaseandbeyond.
WhoThisBookIsForProSQLServer2008MirroringisaimedatSQLServer2008databaseadministratorsandespeciallyatthosewhodesiretomirrortheirdatabasesinsupportofhighavailability.
SystemadministratorsandoperationalengineerswhomanageWindowsServersystemsthatsupportmirroreddatabaseenvironmentswillalsofindmuchofinterestinthebook.
HowThisBookIsStructuredThisbookwalksyouthroughthebasicconfigurationofdatabasemirroringtotheadvancedtopicsyoushouldknowafteritisimplemented.
Chapter1comparesdatabasemirroringwithotherhigh-availabilitytechniquesandevenprovidesasampleplanthatcombinesmultiplehigh-availabilitytechniques.
Chapter2providesyouanoverviewofdatabasemirroring,includingthedifferenttypesofimplementationandthenewfeaturesofferedinSQLServer2008.
Chapter3givesyoutheknowledgeyouneedduringtheplanningphaseofdatabasemirroring,providingyouwithsomebest-practicetechniquesyoushouldknowbeforedeployingdatabasemirroring.
Chapter4coversthebasicsetupofdatabasemirroringusingthedatabasemirroringwizardandalsoprovidesstep-by-stepinstructionstosetupdatabasemirroringusingT-SQL.
Chapter5providesyouthescriptsyouneedinordertoquicklyautomatedatabasemirroringsetupforseveraldatabasesatonceinordertoavoidthetime-consumingprocessofconfiguringdatabasemirroringonasingledatabaseatatime.
Chapter6providesyouthemaintenancescriptsyouneedtorunonyourdatabasemirroringserversinordertokeepthemrunningsmoothly.
Chapter7coversthevarioustechniquesyouneedtoknowinordertomonitordatabasemirroringandtoalertyouwhencertainunwantedconditionsarise.
Chapter8walksyouthroughthestepstoperformasuccessfuldatabasemirroringupgradeincludingpre-andpost-upgradeconsiderations.
INTRODUCTIONxvChapter9coversthevariousreportingoptionsyouhavewithdatabasemirroringbytakingadvantageofdatabasesnapshots,logshipping,andreplication.
Chapter10stressestheimportanceofknowinghowyourdatabasemirroringconfigurationwillreacttodifferenttypesoffailuresandwhatyoushoulddotobepreparedforthem.
PrerequisitesDatabasemirroringwasintroducedinSQLServer2005butwasn'tofficiallysupporteduntilServicePack1.
Youcanrundatabasemirroringintheoriginalrelease,butyouwillneedtosetatraceflag.
Inordertorunthesamplesinthisbookhowever,werecommendrunningSQLServer2005ServicePack1orgreater,andifatallpossibleServicePack3.
However,inordertotakeadvantageofallofthelatestfeatures,youwillneedtoberunningSQLServer2008.
DownloadingtheCodeYoucandownloadthesourcecodeforthebookontheApresswebsiteintheSourceCodesectionathttp://www.
apress.
com/book/sourcecode.
AlloftheT-SQLcodewillbein.
sqlfilesprefacedwiththenameofthestoredproceduresusedinthebook.
TherewillbeonePowerShellscriptwitha.
ps1extension.
ThesampledatabasesarenolongerprovidedasapartoftheSQLServer2008installation.
Ifyouwanttodownloadasetofsampledatabasesyoucanusefortestingpurposes,theycanbefoundontheCodePlexwebsiteathttp://www.
codeplex.
com/MSFTDBProdSamples.
YouwillwanttodownloadtheSQLServer2008ProductSampleDatabasesfromthiswebsiteandfollowtheinstallationinstructions.
ContactingtheAuthorsYoucancontactKenSimmonsbye-mailinghimatcyberjunkyks@yahoo.
com,oryoucanvisithisblogathttp://cybersql.
blogspot.
com.
Therewillbeatagonhisblogcalled"ProSQLServer2008Mirroring"youcanusetofilterpoststhataredirectlyrelatedtothebook.
Pleaseincludethebooktitleinanye-mailstohelpidentifyquestionsorcommentsaboutthebook.

华为云年中聚惠618活动,新用户专区,云服务器低至88元/年,3年仅580.98元,热销抢购中,最后2天!

华为云怎么样?华为云用在线的方式将华为30多年在ICT基础设施领域的技术积累和产品解决方案开放给客户,致力于提供稳定可靠、安全可信、可持续创新的云服务,做智能世界的“黑土地”,推进实现“用得起、用得好、用得放心”的普惠AI。华为云作为底座,为华为全栈全场景AI战略提供强大的算力平台和更易用的开发平台。本次年终聚惠618活动相当给力,1核2G内存1m云耀云服务器仅88元/年起,送主机安全基础版套餐,...

2021年国内/国外便宜VPS主机/云服务器商家推荐整理

2021年各大云服务商竞争尤为激烈,因为云服务商家的竞争我们可以选择更加便宜的VPS或云服务器,这样成本更低,选择空间更大。但是,如果我们是建站用途或者是稳定项目的,不要太过于追求便宜VPS或便宜云服务器,更需要追求稳定和服务。不同的商家有不同的特点,而且任何商家和线路不可能一直稳定,我们需要做的就是定期观察和数据定期备份。下面,请跟云服务器网(yuntue.com)小编来看一下2021年国内/国...

UCloud优刻得,新增1核1G内存AMD快杰云机型,服务器2元/首月,47元/年

UCloud优刻得近日针对全球大促活动进行了一次改版,这次改版更加优惠了,要比之前的优惠价格还要低一些,并且新增了1核心1G内存的快杰云服务器,2元/首年,47元/年,这个价格应该是目前市面上最低最便宜的云服务器产品了,有需要国内外便宜VPS云服务器的朋友可以关注一下。UCloud好不好,UCloud服务器怎么样?UCloud服务器值不值得购买UCloud是优刻得科技股份有限公司旗下拥有的云计算服...

server2008为你推荐
虚拟主机价格虚拟主机及域名价格?海外主机美国主机哪个好,最好是速度和稳定性能跟得上?香港虚拟空间最好的香港虚拟主机是哪家?虚拟主机评测网求推荐一些适合个人博客网站的虚拟主机的服务商上海虚拟主机我想购买虚拟主机,选个品牌。大家给点意见。电信为主。当然肯定要支持多线。合肥虚拟主机虚拟主机哪里买好一些?云南虚拟主机云南服务器托管域名交易域名交易的流程是怎么样的?域名服务器什么是服务器和域名新网域名新网域名如何办理过户?
t楼 名片模板psd win8升级win10正式版 丹弗 数字域名 双拼域名 申请个人网站 电子邮件服务器 合租空间 上海服务器 smtp服务器地址 双线空间 512内存 winserver2008 WHMCS 服务器是什么 木马检测 bwg let dbank 更多