SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is database mirroring used much in the industry?


Is database mirroring used much in the industry?

Author
Message
Golfer22
Golfer22
SSC-Addicted
SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)

Group: General Forum Members
Points: 466 Visits: 96
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?
Joie Andrew
Joie Andrew
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6727 Visits: 2032
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"
Adi Cohn
Adi Cohn
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8495 Visits: 6595
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/
TheSQLGuru
TheSQLGuru
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33443 Visits: 8682
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 on googles mail service
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search