1 / 24

Roy Ernest Database Administrator Pinnacle Sports Worldwide royernest@yahoo.com

SQL Server High Availability. Roy Ernest Database Administrator Pinnacle Sports Worldwide royernest@yahoo.com. Contents. What is High Availability (HA) What is Disaster Recovery (DR) What are the options of HA Database Mirroring Cons of database mirroring. What is HA.

kiet
Download Presentation

Roy Ernest Database Administrator Pinnacle Sports Worldwide royernest@yahoo.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server High Availability Roy Ernest Database Administrator Pinnacle Sports Worldwide royernest@yahoo.com

  2. Contents • What is High Availability (HA) • What is Disaster Recovery (DR) • What are the options of HA • Database Mirroring • Cons of database mirroring Curaçao SQL Server User Group

  3. What is HA • High availability is the percentage of Uptime of your applications. • HA percentage is defined by your SLA. • There are different methods to achieve this. Curaçao SQL Server User Group

  4. What is DR Disaster recovery is the method by which you can minimize the impact of a disaster. Two types of disasters are 1. Physical 2. Logical How can we recover from a disaster? Curaçao SQL Server User Group

  5. What are the options available for HA? • Database Clustering. • Log Shipping. • Replication. • Database Mirroring. Curaçao SQL Server User Group

  6. Database Mirroring • What is Database mirroring? • Pros of Database mirroring. • Things to watch out for. • Replication • Adding file group Curaçao SQL Server User Group

  7. Curaçao SQL Server User Group • How to setup Database mirroring? • Make sure that the DB is in FULL Mode. • Take a back up, transaction log back up • Restore back up and T-Log to mirror with NORECOVERY • Use GUI from the Primary to set up mirror. Jan 27th, 2011 7

  8. Curaçao SQL Server User Group Primary use master go Backup database AdventureWorks to disk ='E:\ADW.Bak' with init,Compression go Backup log AdventureWorks to disk ='E:\ADW.trn' with init,Compression go Jan 27th, 2011 8

  9. Curaçao SQL Server User Group Secondary. In the Master Database execute restore database AdventureWorks from disk ='E:\ADW.Bak' with norecovery, replace, move 'AdventureWorks_Data' to 'E:\Denali\Data\AdventureWorks_data.mdf', move 'AdventureWorks_log' to 'C:\Denali\Log\AdventureWorks_log.ldf', stats = 10 go Jan 27th, 2011 9

  10. Curaçao SQL Server User Group Secondary. In the Master Database execute restore log AdventureWorks from disk ='E:\ADW.trn' with norecovery, replace,move 'AdventureWorks_Data' to 'E:\Denali\Data\AdventureWorks_data.mdf', move 'AdventureWorks_log' to 'C:\Denali\Log\AdventureWorks_log.ldf', stats = 10 go Jan 27th, 2011 10

  11. Curaçao SQL Server User Group Jan 27th, 2011 11

  12. Curaçao SQL Server User Group Jan 27th, 2011 12

  13. Curaçao SQL Server User Group Jan 27th, 2011 13

  14. Curaçao SQL Server User Group Jan 27th, 2011 14

  15. Curaçao SQL Server User Group Jan 27th, 2011 15

  16. Curaçao SQL Server User Group Jan 27th, 2011 16

  17. Curaçao SQL Server User Group Jan 27th, 2011 17

  18. Curaçao SQL Server User Group Jan 27th, 2011 18

  19. Curaçao SQL Server User Group Jan 27th, 2011 19

  20. Curaçao SQL Server User Group Jan 27th, 2011 20

  21. Curaçao SQL Server User Group Jan 27th, 2011 21

  22. Curaçao SQL Server User Group Jan 27th, 2011 22

  23. Conclusion Curaçao SQL Server User Group

  24. DANKI! Curaçao SQL Server User Group

More Related