No announcements
Found 2202202 threads
-
0 VotesMirroring - Performance issues with High safety synchronous mode with sql standard edition
Hi, In standard edition mirroring, when synchronous mode is only possible option: 1: Does that ...Answered | 3 Replies | 2236 Views | Created by Asam, Muhammad - Wednesday, September 25, 2013 11:38 PM | Last reply by Shanky_621 - Thursday, September 26, 2013 7:40 AM
-
0 Votes
SQL Cluster + high-safety, synchronous mirroring?
An alternative would be to set the mirror to high-safety (no data loss) but without automatic failover.Answered | 11 Replies | 1313 Views | Created by jadedpuppy - Thursday, April 9, 2015 10:42 PM | Last reply by jadedpuppy - Friday, April 10, 2015 6:58 PM -
0 Votes
Question about database mirroring with "high-safety mode without automatic failover"
David, You're assuming that the mirroring session is always 'synchronized' but in the case of what you're asking, it happens - as stated in the article - that this ...Answered | 4 Replies | 2986 Views | Created by AragornEllessar - Monday, January 14, 2013 1:54 PM | Last reply by AragornEllessar - Tuesday, January 15, 2013 4:15 PM -
3 Votes
High-Availability with Database Mirroring
Synchronous mode - SAFETY is always set to FULL ( Transactions gets committed at both the partners simultaneously) Synchronous ...Answered | 6 Replies | 7626 Views | Created by Jon Alfred Smith - Sunday, October 30, 2011 11:07 AM | Last reply by Trevor Seward - Tuesday, November 1, 2011 4:43 AM -
0 Votes
Mirroring and the safety mode settings during an outage on the principal.
i.e., would it be in High Safety mode but apply the old transactions in High Performance mode and then once it's caught up, then it ...Answered | 3 Replies | 3399 Views | Created by altrstar - Sunday, November 4, 2012 11:37 PM | Last reply by Balmukund - Monday, November 5, 2012 12:51 AM -
0 Votes
Enabling Mirroring causes performance penalty.
High-safety mode supports synchronous operation, and high-performance mode runs asynchronously.Answered | 1 Replies | 6486 Views | Created by JoeSchmoe115 - Friday, September 28, 2012 8:43 PM | Last reply by Shulei Chen - Monday, October 1, 2012 8:44 AM -
0 Votes
Diffrent in performance between mirror with safey full and always-on with synchronize mode
You are planning to use MSDTC with mirroring/Always-On?Answered | 2 Replies | 736 Views | Created by Gal1 - Sunday, May 4, 2014 9:21 PM | Last reply by Erland Sommarskog - Monday, May 5, 2014 10:14 AM -
0 Votes
SAFETY FULL and SAFETY OFF
Are you using Standard Edition?Answered | 6 Replies | 18192 Views | Created by learningdba - Thursday, August 28, 2008 11:58 AM | Last reply by Ajay.G - Monday, November 15, 2010 11:08 AM -
0 Votes
Is there any special steps for consideration when switching between asynchronous mirroring versus synchronous mirroring?
No, that is not what i am saying, Witness in synchronous mode is safe and provides automatic failover for your mirroring session ( there could be issues with it if ...Answered | 10 Replies | 1479 Views | Created by kimdav111 - Friday, July 24, 2015 9:41 PM | Last reply by SQLGru - Monday, July 27, 2015 3:38 PM -
0 Votes
Where to place witness server for SQL mirroring using high-safety and auto-failover, 2 sites (protected and DR)
A simple solution to this configuration issue (Mirror and Witness at DR site, Principal at LIVE site) is to have a switched off cloned witness vm at the LIVE site.Answered | 3 Replies | 1685 Views | Created by jadedpuppy - Thursday, April 9, 2015 10:39 PM | Last reply by CozzaroNero - Tuesday, November 10, 2015 4:57 PM -
0 Votes
Async mode with Safety Level combination
No - In Asynchromous mode their will be posibility to lose commeted transactions.Answered | 2 Replies | 8674 Views | Created by Ragu Thangavel - Monday, April 25, 2011 8:32 AM | Last reply by RamJaddu - Tuesday, April 26, 2011 1:50 PM -
0 Votes
high-protection mode will decares the Performance
For example, network latency, disk subsystem, SQL Server Editions and Versions will all affect how fast your mirroring can be.Answered | 1 Replies | 6243 Views | Created by RajeshSql - Friday, April 27, 2012 2:03 PM | Last reply by Andrew Bainbridge - Friday, April 27, 2012 3:45 PM -
2 Votes
mirroring on sql server 2008 standard edition
(yes, BOL has issues in some places) You can mirror from 2005 to 2008 or 2008 R2 just fine.Answered | 5 Replies | 10243 Views | Created by kneeah - Tuesday, May 24, 2011 9:55 AM | Last reply by Prasad Yangamuni - Thursday, May 26, 2011 5:17 AM -
0 Votes
How to failover database mirror in high performace model?
This is the tradeoff you accept when running in High Performance versus High Availability mode.Answered | 4 Replies | 5065 Views | Created by Wison-Ho - Monday, April 19, 2010 1:39 AM | Last reply by Jonathan Kehayias - Tuesday, April 20, 2010 4:51 AM -
0 Votes
Best Location for SQL Mirroring witness Server .
For information about how a witness affects database availability in a high-performance mode session, see Asynchronous Database Mirroring ...Answered | 3 Replies | 2508 Views | Created by I S Priyankara - Thursday, October 6, 2016 5:05 PM | Last reply by S_NO - Friday, October 7, 2016 9:07 AM -
0 Votes
logs for 'Operating mode' change in mirroring
All of our mirrorings are working on 'high Performance'(Aysnch) operating mode,all of sudden we noticed that one of the servers has 'High safty'(synch) ...Answered | 10 Replies | 2535 Views | Created by Mourmansk - Tuesday, September 17, 2013 11:49 PM | Last reply by Tom Phillips - Tuesday, January 21, 2014 1:08 PM -
0 Votes
Want to Buy SQL 2008/2012 standard edition to achieve Database failover
Just to add to what shanky has said, Database mirroring in Standard Editions of SQL Only works in Full Safety Mode...Answered | 4 Replies | 1241 Views | Created by vishalagavane - Friday, December 19, 2014 11:38 AM | Last reply by Ashwin Menon - Friday, December 19, 2014 12:48 PM -
1 Votes
Mirroring Issue
1) the database name on the mirror and principal must be the same 2) the mirrored database on the principal must be and remain in full recovery ...Answered | 2 Replies | 6879 Views | Created by SivaReddyG - Thursday, January 20, 2011 4:57 AM | Last reply by Hilary Cotter - Thursday, January 20, 2011 10:52 AM -
1 Votes
SQL High Availability between Main and DR site with SQL Standard Edition
You need SQL 2012 Entperprise edition for an Availability group.Answered | 12 Replies | 564 Views | Created by EMAS-schoemandre - Tuesday, April 18, 2017 11:57 AM | Last reply by Edwin M Sarmiento - Tuesday, April 18, 2017 8:48 PM -
1 Votes
Database Mirroring
High-safety mode The database mirroring session operates ...Answered | 6 Replies | 4154 Views | Created by Thunga Anil Kumar - Monday, June 25, 2012 2:42 AM | Last reply by Thunga Anil Kumar - Monday, July 9, 2012 4:24 AM - Items 1 to 20 of 2202202 Next ›
No announcements
