SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Replication of sqlserver 2008R2 server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

csaha
Yak Posting Veteran

52 Posts
Posted - 08/01/2012 :  10:37:58  Show Profile  Reply with Quote
I am new to replication and would like to setup Replication so that when one of the database server is down, we can connect the application to another server and will be up and running in few hours. We also do a backup of the databases. I choose Transactional Replication because it is most common replication type and it tracks and replicates to the Subscriber. However while building transactional Replication, I found that I cannot create replication if there are tables without primary key. So does that mean I should look into different kind of replication? Can I build two types of replication in the same server. I have 13 databases in the server and among that I have 9 databases where the tables does not have primary key. I do not know if it is a good idea to build primary key to all those tables. Please advice.
Edited by - csaha on 08/01/2012 10:54:20

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3437 Posts
Posted - 08/01/2012 :  12:06:30  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
you need to have a pk to enable transactional replication. And that's probably what you want..

Someone could probably advise about log shipping though if a fail over cluster is more your cup of tea?

You *should* have a primary key on every table if your design is at all normalized anyway.

Transact Charlie
Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
http://nosqlsolution.blogspot.co.uk/
Go to Top of Page

csaha
Yak Posting Veteran

52 Posts
Posted - 08/01/2012 :  12:30:47  Show Profile  Reply with Quote
If I create primary key to all table because I have quiet a few tables, will it cause any performance issue? Is transactional replication my best choice? What about snapshot, or merge replication.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4967 Posts
Posted - 08/01/2012 :  13:32:07  Show Profile  Visit russell's Homepage  Reply with Quote
If you intend to WRITE to the failover instance in a disaster, then I'd suggest database mirroring or log shipping.

Also have a look at failover clustering
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.03 seconds. Powered By: Snitz Forums 2000