Roy ernest database administrator pinnacle sports worldwide royernest@yahoo com
This presentation is the property of its rightful owner.
Sponsored Links
1 / 24

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


  • 124 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

Roy Ernest Database Administrator Pinnacle Sports Worldwide [email protected]

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

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


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

11


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

12


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

13


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

14


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

15


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

16


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

17


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

18


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

19


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

20


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

21


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Curaçao SQL Server User Group

Jan 27th, 2011

22


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

Conclusion

Curaçao SQL Server User Group


Roy ernest database administrator pinnacle sports worldwide royernest yahoo com

DANKI!

Curaçao SQL Server User Group


  • Login