Solved

How to mirror tables between 2 mssql 2005 databases on 2 diffrent servers?

Posted on 2009-04-06
8
516 Views
Last Modified: 2012-05-06
How do i mirror a few tables in one database to another database on another server? Is it possible or do i have to do some kind of sync between them?
0
Comment
Question by:gobbalobba
  • 3
  • 2
8 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24075664
Do you want mirroring for tables? not for complete database? if that is the case than you should go for replication.
0
 

Author Comment

by:gobbalobba
ID: 24075672
yes between tables. How do i set up replication?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24075681
mirroring will make mirror of full database, if you need table based solution than I would suggest replication. If you like to see more about creating replication than do have a look at below URLs

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html

http://www.informit.com/articles/article.aspx?p=601350

http://www.mssqltips.com/tip.asp?tip=1451
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:gobbalobba
ID: 24075726
nice!
Ill follollow the guides and probobly will get it goin. One question thou, is it sharing thrtough a smb share so that i need to open in the fw between them for smb? or is it purely sql port that is needed?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24075739
SQL port will do.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24076028
If you want to keep two tables in two different databases to be in sync, then the simplest way is to have triggers for INSERT, UPDATE and DELETE statements in the Main Server to have it reflected in the Destination Server.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
install report service in sccm2012 3 19
xml files 7 29
Current Month Filter in Visual Studio 10 23
SQL View / Qtry 3 12
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question