SQL Server 2008 Demo Database Mirroring

http://www.learningsqlserver2008.com/

In this training demo, we cover one of the high availability topics database mirroring. Database mirroring is an excellent choice for high availability. In this training demo on ms SQL 2008 server, we cover Principal, Mirror and Witness servers. You can use 3 modes which are high performance, high safety and high safety with automatic failover in SQL Server 2008. You need to have the database in full recovery model with Filestream disabled. Principal database and Mirror Server.

Visit our other sites:

http://www.learningcomputer.com/
http://www.sqlazuretutorials.com/
http://www.sqlserver2008tutorial.com/
http://compare-insurance-car.com/compare-car-insurance.html
http://mycar-insurance.net/
http://datatechnologyllc.com/search-engine-optimization/Dallas-SEO.html

Category:

Science & Technology

Tags:

• Database Mirroring
• SQL server 2008 Demo
• High Safety
• high performance
• sql services account
• Principal
• Mirror
• and
• Witness
• servers
• MS sql Server
• Mirror (computing)
• Software Tutorial

[Lukex29]

It looks like the mirror and principal are both on the same machine here? what if they are in different locations?

[baghul]

@Lukex29 Luke you are correct, we have two instances on the same machine. In real life the principal would be on one server while the mirror would be a separate physical machine.

[seandeyoung01]

Once again a great job with another one of you videos

[baghul]

@seandeyoung01 Thank you Sean!

Check out our new blog here:

Slackerdba period blogspot period com