Questions tagged [replication]

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

Filter by
Sorted by
Tagged with
19
votes
3answers
9k views

How fast is MySQL replication?

I'm considering setting up replication of our mysql db to be able to have local slaves in each of our branch offices, while having the master in the main office to improve application performance (...
2
votes
2answers
3k views

The concurrent snapshot for publication ‘xx’ is not available because it has not been fully generated or the Log Reader A

I am having all sorts of trouble getting SQL Server (2005) to work properly. When I run the client (SQL Server Express 2005) I get the following error "The concurrent snapshot for publication 'xx' is ...
2
votes
10answers
348 views

Desktop standby solution?

Does anyone know of a good solution to have a Windows desktop standby so that users can be back up and running quickly in case of hardware failure? Assumption is that the desktops aren't generic but ...
5
votes
18answers
6k views

How to Eliminate Tape Backup and Off-site Storage Service?

PLEASE READ UPDATE AT THE BOTTOM. THANKS! ;) Environment Info (all Windows): 2 sites 30 servers site #1 (3TB of backup data) 5 servers site #2 (1TB of backup data) MPLS backbone tunnel connecting ...
2
votes
4answers
2k views

How to set up replication on SQL Server 2008

Say you have a production database and a staging database that you want to have replicate on a semi-hourly basis across the internet. The general intent is to have a stand-by backup, but also to have ...
0
votes
1answer
724 views

SQL Server 2005 on 2008 DC - Cannot change service user

I cannot start SQL Server 2005 transactional replication after I promoted my 2008 Server to a DC. A required privilege is not held by the client. This site suggests that I need to change the SQL ...
3
votes
3answers
2k views

SYSVOL replication over DFS-R

When we migrate our production DCs to Server 2008 I would also like to move away from FSR to DFS-R for SYSVOL replication. My problem is that I setup a quick lab to test it out but it's not going as ...
4
votes
2answers
13k views

Outlook Scheduling Assistant not seeing free/busy consistently

I have Exchange clusters located in 2 different states conencted by a DS3. When I am scheduling a meeting requiring attendees from both locations, I cannot always see free/busy times for users at the ...
3
votes
5answers
2k views

Using MySQL replication to enable a read-only copy of a database in a DMZ

I need to set up a MySQL database instance in a DMZ that is a read-only copy of the live master inside a secure network. MySQL replication seems ideal for this, except that it works by the slave "...
1
vote
5answers
833 views

Low Latency or High Bandwidth, which is more important for database replication?

When considering the placement of an offsite slave database, which is more important in a network connection for maintaining up-to-date replication: low latency or high bandwidth?
1
vote
2answers
853 views

HTTP 401.1 all of the sudden after a server reboot

I am running SQL Server CE replication on a web server and recently replications have been failing. When I try to visit the diag utility (http://webaddress/Replication/SqlCeSa30.dll?Diag I get an ...
1
vote
4answers
371 views

What is the better way to add extra servers for reliability in our case?

We have the following servers: A. 1 x web server running MySQL (a forum). B. 1 x web server running RT with Postgres. C. 1 x web server running a home grown app with MonetDB as the backend Now of ...
3
votes
4answers
2k views

How can I create a slave replica of a MySQL server without stopping the master?

To ensure the data on the slave and master are in the same place for replication, the new master should be stopped and data transferred to the new slave before starting the master again, at least this ...
4
votes
1answer
5k views

SQL mirroring or log-shipping - which has the least impact on a replicated database?

We're planning a server which is a clustered SQL2005 Enterprise 64bit with a database of which a subset of tables are replicated one way via transactional replication to single subscriber located at ...
2
votes
2answers
2k views

Symantec Endpoint Protection - Replicating my sites

I have Symantec Endpoint Protection Installed on a Windows Server 2003 machine, this has VPN links to two other offices with Windows Server 2003 machines. I am trying to replicate Symantec Endpoint ...
3
votes
2answers
18k views

Will the DNS Forward Lookup Zone recreate itself if I delete it?

Here is my situation: I have inherited a Windows 2003 domain with only 1 domain controller, we'll call it DC1. DC1 is also the DNS, DHCP and Exchange server for this organization. DC1 was ...
1
vote
2answers
8k views

Replicate Server 2003 DFS root to Server 2008

I am trying to get a Windows Server 2003 (not R2) DFS root to replicate to Server 2008 Standard. My research so far suggests that adding the File Replication Service role service in the File Services ...
4
votes
4answers
2k views

SQL 2000 Replication error - The subscription(s) have been marked inactive and must be reinitialized

We have a largish database (350GB) which is replicated to a subscriber which is georaphically in a different location. Unfortunateley we have a slow connection between the two sites. Today we're ...
45
votes
10answers
6k views

PostgreSQL Replication

We constantly bat this around the office, and the question continues to come up. How do you deal with PostgreSQL replication? I'm not even necessarily talking about advanced clusters, just keeping it ...
3
votes
3answers
7k views

What are the performance implications for using SQL Server replication?

What are adverse affects to using replication What are some examples of when replication is beneficial
2
votes
2answers
6k views

SQL Server Replication issues

Before I begin - I'm not a DBA type, I'm a software dev type. Our DBA has been out sick for the last week or so, and I've been trying to get a new feature of ours up and running. This new feature ...
7
votes
4answers
12k views

Open Source Alternative to Microsoft's File Replication Services [closed]

We're operating two rather busy locations with 40+Gigs of client data shared on Windows 2003 servers and need to have it replicated (as close to instantaneously as possible) to each. We're ...
1
vote
1answer
585 views

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000, or do you have to use Enterprise Manager or SQL-DMO as mentioned in SQL Server Books Online?...
1
vote
1answer
620 views

Make SQL replicate over separate VLAN

I have two SQL Server 2008 machines, SQL1 and SQL2, doing replication between each other. Their main interfaces are on VLAN1 (10.1.1.0/24) and that's where clients reach them. For performance, I ...
2
votes
2answers
787 views

SQL Server Express 2008 replication/synchronisation

We are looking at developing a small, simple, Access system for a client using SQL Server Express (2005 or 2008) as database. The only complicating factor is they have two offices and they will need ...
2
votes
6answers
6k views

How best to script selected tables and data on SQL Server 2008?

The SQL Server Management Studio has the ability generate scripts. The problem is that it breaks on identity columns. I can't find a link to this bug at the moment but Microsoft basically declared it ...

1 16 17 18 19 20