Is database mirroring used much in the industry?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Is database mirroring used much in the...

Is database mirroring used much in the industry?

Rate Topic

Display Mode

Topic Options

Author

Message

Golfer22

Posted Tuesday, December 25, 2012 7:16 PM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, February 02, 2013 11:13 PM
Points: 82, Visits: 76

I'm curious because some features of SQL Server are not used that frequently in businesses. What types of business environments use database mirroring?

Also, do database checkpoints occur automatically? Or are they just done manually for databases in simple recovery mode?

Post #1400120

Joie Andrew

Posted Wednesday, December 26, 2012 3:03 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:04 PM
Points: 555, Visits: 1,036

I know that we use it in our environment for a HA scenario, but cannot speak for an industry as a whole. If you are looking at upgrading soon you may want to look at Always-On as it is replacing Database Mirroring as the preferred HA option.

Checkpoints happen both automatically by the SQLOS, automatically for certain operations and can happen manually.

CHECKPOINT (Transact-SQL)

Joie Andrew
"Since 1982"

Post #1400191

Adi Cohn-120898

Posted Wednesday, December 26, 2012 3:32 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:50 AM
Points: 2,019, Visits: 4,923

Most chances are that it will get used much more. Partly because it is needed for SQL Server 2012's always on and partly because now the secondary database can be read and used for reports.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1400197

TheSQLGuru

Posted Thursday, December 27, 2012 7:13 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 6:52 PM
Points: 3,582, Visits: 5,132

1) database mirroring can be a WONDERFUL HA tool to put in place. But before ANY entity embarks on an HA implementation they need to REALLY spend some grey matter determining what they NEED and can PAY FOR. Then make a plan, implement, TEST, and monitor. In my 15+ years of SQL Server consulting almost NO entities have done that, from mom-and-pops all the way through Fortune 100 global companies.

2) Yes, checkpoints are done automatically. Look them up in Books Online (a MARVELOUS resource). They can also be done manually.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #1400613

« Prev Topic | Next Topic »

Permissions