Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Replication (2012)
 Two Site Replication
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

lowfreq
Starting Member

Canada
1 Posts

Posted - 06/12/2013 :  13:27:29  Show Profile  Reply with Quote
Im looking at putting in a two server replication model for SQL server 2008.

I'm new to replication, so my question is this...
Our requirement is to have Near Time Sync between two servers, sharing the same instance/data.

Both servers must allow Read and Write.

I've been looking around and I think I need Transactional Replication, but it doesn't say whether writes are permitted to the subscriber.

Thank you for any help you can provide!

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 06/14/2013 :  14:29:55  Show Profile  Visit tkizer's Homepage  Reply with Quote
Have you looked at peer to peer replication?

You should consider SQL Server 2012's AlwaysOn feature where you can have a readable replica. You'd only have one replica that's writing, but you'd have two replicas for reading.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 06/14/2013 :  22:03:20  Show Profile  Visit russell's Homepage  Reply with Quote
Peer to Peer, as Tara pointed out, is probably the way to go. You will need to manage identity columns and make sure all replicated tables have primary keys, but other than that, it's pretty easy to setup and maintain.

As for identity columns, seed them so there can be no conflicts. For example, in a two node topography, seed the identities on one server odd and the other even. DO NOT box yourself in so that you could run out of numbers (like seeding server A at 1 and server B and 1,000,000). There is no conflict resolution in peer to peer, so you will have to ensure that primary key values are distinct accross all nodes in the topology.

In Transactional Replication, the subscriber(s) should be treated as read only, so that's not a candidate in your case.

I personally can't figure out a use for the always on feature in SQL 2012, but could be convinced. Not if you need all noes to be writable obviously.

EDIT: Tara! Good to see you back.

Edited by - russell on 06/14/2013 22:04:48
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 06/19/2013 :  21:10:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by russell


I personally can't figure out a use for the always on feature in SQL 2012, but could be convinced.



Russell, we are currently implementing an AlwaysOn cluster for our most critical product. It will have 6 nodes, 3 at the primary site and 3 at the DR site. One of the nodes at the primary site will be for writes, one of the nodes at the primary site will be for reads (read intent replica), and the third server at the primary site will be a warm standby. The 3 servers at the DR site are in case we lose the primary site. 2 of the servers at the DR site will use async, and the 3 at the primary site will use sync. The last server at the DR site is a cold standby due to an AlwaysOn limitation. All 6 servers have a Fusion-io SSD card, and all 6 are identical hardware (256GB of memory with 4 sockets (8 cores each). These 6 serves will also use a storage array for some of the database load.

The application will use the AG's listener name, regardless of where the primary replica and secondary replica are. So finally no connection string changes when we move production to our DR site for testing!

When on the phone with a Fusion-io engineer a few weeks back, he said in reference to our architecture: wow that's state of the art. This product is absolutely critical, and we've gone all out on it. I'm currently working on the scripts to upgrade the database to 2012, which involves index changes and adding compression. The product is currently back ended by SQL Server 2005 and struggling there. We are using transactional replication for the reports. Can't wait to get rid of replication!



Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 06/26/2013 :  00:34:59  Show Profile  Visit russell's Homepage  Reply with Quote
I love replication lol. Please let me know how it all goes. I've been struggling to find a valid use case, but seems you have one. Thanks.
Go to Top of Page

vidyasagr
Starting Member

India
2 Posts

Posted - 08/13/2013 :  02:30:45  Show Profile  Reply with Quote
Hi, i am newly joined to learn the sql dba, how many issues are facing in Replication and Entire SQL DBA? Please advise me about this.

sagarvidya

Edited by - vidyasagr on 08/13/2013 02:33:06
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 08/13/2013 :  11:38:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by vidyasagr

Hi, i am newly joined to learn the sql dba, how many issues are facing in Replication and Entire SQL DBA? Please advise me about this.

sagarvidya



Please start a new thread for any questions that you may have. Your question isn't clear enough for us to help though, so please explain in further detail (in a new post).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rhein
Starting Member

9 Posts

Posted - 12/17/2017 :  02:57:15  Show Profile  Reply with Quote
[b][url=http://sv.esmoncler.top/]Moncler jackor ytterkläder[/url][/b][b][url=http://www.esmoncler.top/sv/]Moncler jackor ytterkläder[/url][/b]<strong><a href="http://www.esmoncler.top/sv/">Moncler</a></strong> | <strong><a href="http://sv.esmoncler.top/">Moncler</a></strong> | <strong><a href="http://www.esmoncler.top/sv/">Moncler</a></strong><br><title>Frakt & Returer : moncler, esmoncler.top</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><meta name="keywords" content="Moncler Jackor Kvinnor Moncler Västar Kvinnor Moncler Västar Män Moncler Jackor Män Moncler Coats Kvinnor Moncler Coats Män Moncler Sjal Moncler Halsduk & Kepsar moncler Frakt & Returer" /><meta name="description" content="moncler : Frakt & Returer - Moncler Jackor Kvinnor Moncler Västar Kvinnor Moncler Västar Män Moncler Jackor Män Moncler Coats Kvinnor Moncler Coats Män Moncler Sjal Moncler Halsduk & Kepsar moncler" /><meta http-equiv="imagetoolbar" content="no" /><base href="http://sv.esmoncler.top/" /><link rel="canonical" href="http://sv.esmoncler.top/shippinginfo.html" /><link rel="stylesheet" type="text/css" href="http://sv.esmoncler.top/includes/templates/polo/css/style_imagehover.css" /><link rel="stylesheet" type="text/css" href="http://sv.esmoncler.top/includes/templates/polo/css/stylesheet.css" /><link rel="stylesheet" type="text/css" href="http://sv.esmoncler.top/includes/templates/polo/css/stylesheet_css_buttons.css" /><link rel="stylesheet" type="text/css" media="print" href="http://sv.esmoncler.top/includes/templates/polo/css/print_stylesheet.css" /><div style="margin:0 auto; clear:both;"><div id="lang_main_page" style="padding-top:10px; clear:both;text-align:center;margin-right:auto;margin-left:auto;"><b>language:</b><?$top_server=substr(HTTP_SERVER,10);?><a href="http://de."><img src="http://sv.esmoncler.top/langimg/gericon.gif" alt="Deutsch" title=" Deutsch " height="15" width="24"></a>  <a href="http://fr."><img src="http://sv.esmoncler.top/langimg/fricon.gif" alt="Français" title=" Français " height="15" width="24"></a>  <a href="http://it."><img src="http://sv.esmoncler.top/langimg/iticon.gif" alt="italiano" title=" italiano " height="15" width="24"></a>  <a href="http://es."> <img src="http://sv.esmoncler.top/langimg/esicon.gif" alt="Español" title=" Español " height="15" width="24"></a>  <a href="http://pt."><img src="http://sv.esmoncler.top/langimg/pticon.gif" alt="Português" title=" Português " height="15" width="24"></a>  <a href="http://jp."><img src="http://sv.esmoncler.top/langimg/jpicon.gif" alt="???" title=" ??? " height="15" width="24"></a>  <a href="http://ru."><img src="http://sv.esmoncler.top/langimg/ruicon.gif" alt="russian" title=" russian " height="15" width="24"></a>  <a href="http://ar."><img src="http://sv.esmoncler.top/langimg/aricon.gif" alt="arabic" title=" arabic " height="15" width="24"></a>  <a href="http://no."><img src="http://sv.esmoncler.top/langimg/noicon.gif" alt="norwegian" title="norwegian " height="15" width="24"></a>  <a href="http://sv."><img src="http://sv.esmoncler.top/langimg/svicon.gif" alt="swedish" title=" swedish " height="15" width="24"></a>  <a href="http://da."><img src="http://sv.esmoncler.top/langimg/daicon.gif" alt="danish" title=" danish " height="15" width="24"></a>  <a href="http://nl."><img src="http://sv.esmoncler.top/langimg/nlicon.gif" alt="dutch" title=" dutch " height="15" width="24"></a>  <a href="http://fi."><img src="http://sv.esmoncler.top/langimg/fiicon.gif" alt="finland" title=" finland " height="15" width="24"></a>  <a href="http://ie."><img src="http://sv.esmoncler.top/langimg/gaicon.gif" alt="finland" title=" finland " height="15" width="24"></a>  <a href="http://www."><img src="http://sv.esmoncler.top/langimg/icon.gif" alt="English" title=" English " height="15" width="24"></a>  </div></div><div class="tophead"><div class="header_top"><div class="header_top_wrapper"><div class="header_curr"><div id="head_right_bottom"> <div id="head_right_bottom_left"> Welcome! <a href="http://sv.esmoncler.top/index.php?main_page=login">Logga in</a>eller <a href="http://sv.esmoncler.top/index.php?main_page=create_account">Registrera</a> </div> <div id="head_right_bottom_right"> <div id="cartBoxEmpty"><a href="http://sv.esmoncler.top/index.php?main_page=shopping_cart"><img class="cart-icon empty float-left" src="http://sv.esmoncler.top/includes/templates/polo/images/spacer.gif" /></a>din vagn är tom</div> </div> </div> </div><div class="header_nav"><div id="head_right_top"><a href="http://sv.esmoncler.top/index.php?main_page=Payment_Methods">Betalning | </a><a href="http://sv.esmoncler.top/index.php?main_page=shippinginfo">Frakt u0026 Retur | </a><a href="http://sv.esmoncler.top/index.php?main_page=Payment_Methods">Grossist | </a><a href="http://sv.esmoncler.top/index.php?main_page=contact_us">Kontakta oss</a></div></div></div></div><div id="head"><div class="clearBoth" /></div><div id="head_left"> <a href="http://sv.esmoncler.top/"><img src="http://sv.esmoncler.top/includes/templates/polo/images/logo.gif" alt="Powered by Zen Cart :: Konsten att e-handel" title=" Powered by Zen Cart :: Konsten att e-handel " width="220" height="60" /></a></div><div class="clearBoth" /></div> <div id="head_center"> <form name="quick_find_header" action="http://sv.esmoncler.top/index.php?main_page=advanced_search_result" method="get"><input type="hidden" name="main_page" value="advanced_search_result" /><input type="hidden" name="search_in_description" value="1" /><div class="search-header-input"><input type="text" name="keyword" size="32" maxlength="130" value="Sök..." onfocus="if (this.value == 'Sök...') this.value = '';" onblur="if (this.value == '') this.value = 'Sök...';" /></div><div class="button-search-header"><input type="image" src="http://sv.esmoncler.top/includes/templates/polo/images/search_header_button.gif" value="Serch" /></div></form> </div><div class="clearBoth" /></div><div id="topnavdiv"><div id="nav"><li class="home-link"><a href="http://sv.esmoncler.top/">Hem</a></li><li class="menu-mitop" ><a href="http://sv.esmoncler.top/moncler-mens-c-6.html">HERR</a></li><li class="menu-mitop"><a href="http://sv.esmoncler.top/moncler-womens-c-1.html">KVINNO-</a></li><li><a href="http://sv.esmoncler.top/new-arrivals-c-1.html">Nyankomna</a></li><li class="menu-mitop"><a href="http://sv.esmoncler.top/featured_products.html">Utvalda</a></li><li><a href="http://sv.esmoncler.top/index.php?main_page=contact_us">Kontakta oss</a></li></div><div class="hidemenu"><ul class="hideul" id="hidul1"></ul><ul class="hideul" id="hidul2"></ul></div></div><div class="clearBoth"></div></div><div id="content"><table width="100%" border="0" cellspacing="0" cellpadding="0" id="contentMainWrapper"> <tr> <td id="navColumnOne" class="columnLeft" style="width: 220px"><div id="navColumnOneWrapper" style="width: 220px"><div class="leftBoxContainer" id="currencies" style="width: 220px"><div class="sidebox-header-left "><h3 class="leftBoxHeading " id="currenciesHeading"><label>Valuta</label></h3></div><div id="currenciesContent" class="sideBoxContent centeredContent"><form name="currencies_form" action="http://sv.esmoncler.top/" method="get"><select name="currency" onchange="this.form.submit();"> <option value="USD">US Dollar</option> <option value="EUR">Euro</option> <option value="GBP">GB Pound</option> <option value="CAD">Canadian Dollar</option> <option value="AUD">Australian Dollar</option> <option value="JPY">Jappen Yen</option> <option value="NOK">Norske Krone</option> <option value="SEK" selected="selected">Swedish Krone</option> <option value="DKK">Danish Krone</option> <option value="CNY">CNY</option></select><input type="hidden" name="main_page" value="shippinginfo" /></form></div></div><div class="leftBoxContainer" id="categories" style="width: 220px"><div class="sidebox-header-left main-sidebox-header-left"><h3 class="leftBoxHeading main-sidebox-header-right" id="categoriesHeading">Kategorier</h3></div><div id="categoriesContent" class="sideBoxContent"><div class="categories-top-list no-dots"><a class="category-top" href="http://sv.esmoncler.top/moncler-halsduk-kepsar-c-8.html">Moncler Halsduk & Kepsar</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-sjal-c-7.html">Moncler Sjal</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-coats-kvinnor-c-5.html">Moncler Coats Kvinnor</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-coats-m%C3%A4n-c-6.html">Moncler Coats Män</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-jackor-kvinnor-c-1.html">Moncler Jackor Kvinnor</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-jackor-m%C3%A4n-c-4.html">Moncler Jackor Män</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-v%C3%A4star-kvinnor-c-2.html">Moncler Västar Kvinnor</a></div><div class="categories-top-list "><a class="category-top" href="http://sv.esmoncler.top/moncler-v%C3%A4star-m%C3%A4n-c-3.html">Moncler Västar Män</a></div></div></div><div class="leftBoxContainer" id="featured" style="width: 220px"><div class="sidebox-header-left "><h3 class="leftBoxHeading " id="featuredHeading">Utvalda - <a href="http://sv.esmoncler.top/featured_products.html">  [mer]</a></h3></div><div class="sideBoxContent centeredContent"><a href="http://sv.esmoncler.top/2013-new-arrivals-moncler-dunjackor-mens-brief-punkt-blac-p-79.html"><img src="http://sv.esmoncler.top/images/_small//moncler82801_/Moncler-Jackets-Men/2013-New-Arrivals-Moncler-Down-Jackets-Mens-Brief.jpg" alt="2013 New Arrivals ! Moncler dunjackor Mens Brief Punkt Blac" title=" 2013 New Arrivals ! Moncler dunjackor Mens Brief Punkt Blac " width="130" height="156" /></a><a class="sidebox-products" href="http://sv.esmoncler.top/2013-new-arrivals-moncler-dunjackor-mens-brief-punkt-blac-p-79.html">2013 New Arrivals ! Moncler dunjackor Mens Brief Punkt Blac</a><div><span class="normalprice">SEK 13,183 </span> <span class="productSpecialPrice">SEK 2,361</span><span class="productPriceDiscount"><br />Spara: 82% mindre</span></div></div><div class="sideBoxContent centeredContent"><a href="http://sv.esmoncler.top/moncler-unisex-vest-vadderad-varmare-kropp-navy-p-12.html"><img src="http://sv.esmoncler.top/images/_small//moncler82801_/Moncler-Vests-Women/Moncler-Down-Unisex-Vest-Quilted-Warmer-Body-Navy.jpg" alt="Moncler Unisex- Vest - vadderad Varmare Kropp Navy" title=" Moncler Unisex- Vest - vadderad Varmare Kropp Navy " width="130" height="167" /></a><a class="sidebox-products" href="http://sv.esmoncler.top/moncler-unisex-vest-vadderad-varmare-kropp-navy-p-12.html">Moncler Unisex- Vest - vadderad Varmare Kropp Navy</a><div><span class="normalprice">SEK 7,958 </span> <span class="productSpecialPrice">SEK 2,249</span><span class="productPriceDiscount"><br />Spara: 72% mindre</span></div></div><div class="sideBoxContent centeredContent"><a href="http://sv.esmoncler.top/moncler-rod-coat-down-m%C3%A4n-svart-p-65.html"><img src="http://sv.esmoncler.top/images/_small//moncler82801_/Moncler-Coats-Men/Moncler-Rod-Coat-Down-Men-Black.jpg" alt="Moncler Rod Coat Down Män Svart" title=" Moncler Rod Coat Down Män Svart " width="130" height="148" /></a><a class="sidebox-products" href="http://sv.esmoncler.top/moncler-rod-coat-down-m%C3%A4n-svart-p-65.html">Moncler Rod Coat Down Män Svart</a><div><span class="normalprice">SEK 8,226 </span> <span class="productSpecialPrice">SEK 2,232</span><span class="productPriceDiscount"><br />Spara: 73% mindre</span></div></div></div></div></td> <td id="columnCenter" valign="top"> <div id="navBreadCrumb"> <a href="http://sv.esmoncler.top/">Hem</a> :: Frakt & Returer</div><div class="centerColumn" id="shippingInfo"><h1 id="shippingInfoHeading">Frakt & Returer</h1><div id="shippingInfoMainContent" class="content"><p> Denna texten kan <strong><a href="http://sv.esmoncler.top/">Moncler jackor ytterkläder</a></strong><br><strong><a href="http://www.esmoncler.top/sv/">Moncler jackor ytterkläder</a></strong><br><br><br><a href="http://CheapRolexWatches3.webs.com"> Västar blog </a><br><br><a href="http://cheapweddingdressesonline0.webs.com"> Moncler </a><br><br><a href="http://luxurywatchesonline40.webs.com"> About esmoncler.top blog </a>
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000