Tagged Questions
0
votes
0answers
25 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
2answers
52 views
Can I use replication/mirroring to have a “Current” database and a “Full History” copy?
I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it.
Most of the data is older and is very rarely needed.
I am ...
3
votes
2answers
153 views
SQL Server replication for off site copy
We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors).
These are mirrored to other backup servers in ...
0
votes
1answer
286 views
Resuming Replication w/ Database Mirroring when Principle is unavailable
I'm trying to setup a disaster recovery scenario and I'm stuck at this particular point. Here's what I've done so far:
A) Created principal database on Server A and and mirror on Server B
...
3
votes
1answer
299 views
Best Approach for Mirroring Data from SQL Server to MySQL
I need help in regards to replicating data from a third party point-of-sale system with a SQL Server backend to a MySQL DB.
Specifically, can anyone suggest a best way to mirror data from SQL ...
4
votes
2answers
902 views
Read-only copy of SQL Server database
We have main database, through out day we insert/update this DB through main application(windows). We have another web application which is suppose to just display content from main DB but instead we ...
4
votes
3answers
979 views
How to sync the data between two identical DB
The thing is I've two identical databases, one is in my localhostserver at my laptop and the other one is on the office main server. Is there any automatic way or software that can synchronize the ...
