SQL 2008 Replication

Posted by sevenlamp on Server Fault See other posts from Server Fault or by sevenlamp
Published on 2009-12-22T08:26:30Z Indexed on 2010/03/31 21:03 UTC
Read the original article Hit count: 249

Filed under:

database-replication

I have replicated two database in SQL2008.

The last two days the distribution database from publisher server changed to Suspect Mode and the replication process is down.

I read a lot from Google and tried to repair, but without success.

During my repairing process, the Distribution Database is has changed to Emergency mode.

Can anyone please kindly suggest any solutions?

Related posts about database-replication

Database replication with composite keys?

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the MySQL documentation on database replication, "All tables replicated using row-based replication must have explicit primary keys." Is it safe to assume that database replication will work with a composite keys? >>> More
Setup database replication between 2 servers.

as seen on Server Fault - Search for 'Server Fault'
Is it possible to setup replication of oracle databases, with one server outside the firewall? If so any suggestions on how to setup would be great. >>> More
ShoreTel Database Replication And Manipulation Of MAXDBQUERIES!

as seen on Article City - Search for 'Article City'
It really doesn?t matter what VoIP system you installed they all generally have one architectural characteristic in common; the configuration database. Depending on the system, you might find a datab... [Author: Peter Buswell - Computers and Internet - May 20, 2010] >>> More
PostgreSQL 9.1 Database Replication Between Two Production Environments with Load Balancer

as seen on Server Fault - Search for 'Server Fault'
I'm investigating different solutions for database replication between two PostgreSQL 9.1 databases. The setup will include two production servers on the cloud (Amazon EC2 X-Large Instances), with an elastic load balancer. What is the typical database implementation for for this type of setup? … >>> More
Database Replication

as seen on Stack Overflow - Search for 'Stack Overflow'
I have tried to follow the steps outlined in http://www.howtoforge.com/mysql_database_replication for Database Replication. I have created the database exampledb, and create some tables and load them with values. But when I execute USE exampledb; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; I… >>> More

Developer IT

SQL 2008 Replication - Developer IT

SQL 2008 Replication

database-replication

Related posts about database-replication

Database replication with composite keys?

Setup database replication between 2 servers.

ShoreTel Database Replication And Manipulation Of MAXDBQUERIES!

PostgreSQL 9.1 Database Replication Between Two Production Environments with Load Balancer

Database Replication

Categories cloud