Roy ernest database administrator pinnacle sports worldwide royernest@yahoo com
Download
1 / 24

Roy Ernest Database Administrator Pinnacle Sports Worldwide [email protected] - PowerPoint PPT Presentation


  • 174 Views
  • Uploaded on

SQL Server High Availability. Roy Ernest Database Administrator Pinnacle Sports Worldwide [email protected] 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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Roy Ernest Database Administrator Pinnacle Sports Worldwide [email protected]' - kiet


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Roy ernest database administrator pinnacle sports worldwide royernest@yahoo com

SQL Server High Availability

Roy Ernest

Database Administrator

Pinnacle Sports Worldwide

[email protected]


Contents
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


What is ha
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


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


What are the options available for ha
What are the options available for HA?

  • Database Clustering.

  • Log Shipping.

  • Replication.

  • Database Mirroring.

Curaçao SQL Server User Group


Database mirroring
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


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


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


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


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














Conclusion

Curaçao SQL Server User Group


DANKI!

Curaçao SQL Server User Group


ad