پاورپوینت کامل Microsoft SQL Server 53 اسلاید در PowerPoint

توجه : این فایل به صورت فایل power point (پاور پوینت) ارائه میگردد

 پاورپوینت کامل Microsoft SQL Server 53 اسلاید در PowerPoint دارای ۵۳ اسلاید می باشد و دارای تنظیمات کامل در PowerPoint می باشد و آماده ارائه یا چاپ است

شما با استفاده ازاین پاورپوینت میتوانید یک ارائه بسیارعالی و با شکوهی داشته باشید و همه حاضرین با اشتیاق به مطالب شما گوش خواهند داد.

لطفا نگران مطالب داخل پاورپوینت نباشید، مطالب داخل اسلاید ها بسیار ساده و قابل درک برای شما می باشد، ما عالی بودن این فایل رو تضمین می کنیم.

توجه : در صورت  مشاهده  بهم ریختگی احتمالی در متون زیر ،دلیل ان کپی کردن این مطالب از داخل فایل می باشد و در فایل اصلی پاورپوینت کامل Microsoft SQL Server 53 اسلاید در PowerPoint،به هیچ وجه بهم ریختگی وجود ندارد

بخشی از مطالب داخلی اسلاید ها

پاورپوینت کامل Microsoft SQL Server 53 اسلاید در PowerPoint

اسلاید ۴: So, you need to make your production database bulletproof…Introduction to Data Availability4

اسلاید ۵: Data Availability ContinuumDegrees of protection for information systems:Business RiskSolutionData RecoveryData lossRedundant dataHigh AvailabilityDowntime of database serviceRedundant system componentsDisaster RecoveryDowntime of business operationsRedundant systems and facilities5

اسلاید ۶: Business Case for AvailabilityKeep business-critical applications availableSecondary:Server maintenanceProtect against loss of data centerSecondary:Application upgradesInfrastructure upgradesHigh AvailabilityDisaster Recovery6

اسلاید ۷: Service Level Agreement (SLA)Permitted downtime (planned vs. unplanned)Acceptable data/transaction lossApplication response timesMean time to recoveryNote: Database uptime is not equivalent to application availabilityFailures of other application servicesNetwork outagesUptime SLADowntime per YearDowntime per Month99.9%8.76 hours43.8 minutes99.99%52.6 minutes4.38 minutes99.999%5.26 minutes0.438 minutes7

اسلاید ۸: Protect WhatApplication data storesDatabasesFilesOther data repositoriesDatabase servicesDBMS availability for applicationsApplication servicesApplication availability for users and external systemsDatabases are the heart of most information systems; they deserve the highest affordable protection.8

اسلاید ۹: Database Failure ScenariosStorage subsystemDiskControllerNetworkServerPowerOperator errorsDBMS interruptionDrops / deletesApplication defectsDBMS defectsData corruptionPhysical Infrastructure FailuresLogical Data Failures9

اسلاید ۱۰: Service Recovery StrategiesStandby ModeFailover BehaviorSQL Server FeatureCold standbyManual intervention required to restore offline data copyBackup and restoreWarm standbyData copy online and readyManual failover requiredTransaction log shippingDatabase mirroringHot standbyAutomatic failoverDatabase mirroringFailover clustering10

اسلاید ۱۱: Data Recovery—TerminologyTerminology varies for source vs. copyHigh Availability StrategyData SourceData CopyBackup and RestoreDatabaseBackupLog ShippingPrimarySecondary StandbyDatabase MirroringPrincipalMirrorFailover ClusteringPrimary ActiveSecondary Passive Standby Inactive11

اسلاید ۱۲: [Briefly…]Data Recovery12

اسلاید ۱۳: Database BackupsTraditional backup typesFull backupDifferential backupTransaction log backupDisk is better than tapeFirst backup to disk (separate physical disk volume)Detect exceptions encountered during backupVerify backup filesCopy backup files to tape or remote diskData retention policy for backup files13

اسلاید ۱۴: Database Backup StrategyBackup of user databases not sufficient for recoverySystem databaseMaster databaseMSDB databaseModel databaseExternal data stores…۱۴

اسلاید ۱۵: Synch with External Data StoresSynchronize recovered database with external data stores:Identity column seedsFull-text indexes (SQL Server 2000)LDAP entriesFile system objectsOther databases15

اسلاید ۱۶: Backup Retention PolicyLocation of backup filesDuration of retentionProtection of sensitive dataSarbanes/Oxley (SOX)HIPAAInternal policies for data management and protectionAccess to backups from offsite data storage16

اسلاید ۱۷: Data Recovery ProcessBackup file setsFull baseline, differential, and transaction logsRetrieving backup filesOffsite storageTapeNetwork copyDependency on multiple people to get access to backup filesRecovery strategy depends on failure scenarioCreate comprehensive failure matrixDevise recovery strategy for each scenarioDoes worst-case recovery scenario fit within SLA parametersRecovery time; SLAInclude future data growth in recovery planFully test recovery strategies—practice is essential17

اسلاید ۱۸: High Availability18

اسلاید ۱۹: High AvailabilityMinimize or avoid service downtimeWhether planned or unplannedWhen components fail, service interruption is brief or non-existentAutomatic failoverEliminate single points of failure (as affordable)Redundant componentsFault-tolerant servers19

اسلاید ۲۰: Redundant ComponentsObjective: Avoid single points of failure (where affordable)Approach: Use redundant components for database serviceDatabase server nodesServer componentsECC RAM; failure-tolerant HW & OSDBMS instanceUser databasesStorage devicesStorage unit componentsMPIO: Interfaces; paths; switches; controllersRAID: DisksNetworkingMPIO: Interfaces; paths; switchesData copiesE.g. Recovering torn page from mirror in SQL Server 200820

اسلاید ۲۱: Transaction Log ShippingWarm standby solutionDuplicate user databaseCopy transaction logs to standby server & restoreDatabase available for read-only accessUsers must disconnect for logs to be appliedTwo database licenses required if querying standbyManual application failoverSupported on standard hardwarePossible data loss (unapplied transactions)21

اسلاید ۲۲: Database MirroringRedundancy at user database levelDuplicate copy of user databaseIndependent storage devicesMultiple copies of instance databasesMirrored over private network channelMirr