Was recently researching replication options for our SQL backend support for
our web apps. I originally wanted to configure Peer-To-Peer replication for
our DB's but for the life of me, could not find any articles on how to
configure (if it's even possible) failover for active ...

I have a merge replication with 20 subscribers.
From a while the CPU Utilization on the server(It's distributor and
publisher of the same time)
is 100%. If i stop subscribers the CPU utilization is going back to normal.

I'm recently in middle of implementation of database synchronization with
two different databases and different information. Here is short detail:
In my Database, there are two tables and they are created by replication
(because my database is part of subscription database) and ...

Hello,
are there any way to know if a push subscription has finished on a
replication process?. Are there any sentence in SQL Server 2000 to get that
information over different tables, ... ?.

I have an environment that consists of approximately 15 production and test
2000 and 2005 servers each with 3 (production) to 8 (test) instances.  I am
trying to create a management application whereby one server (central) (SQL
Server 2005) aggregates information from all ...

We have Merge Replication running between two SQL Server 2005 servers (Std
Edition - x64 bit). Both the servers are on the same network.
We were getting these Error messages:
The Publisher failed to allocate a new set of identity ranges for the

I manage a network for a small company with 3 locations.  They are currently
using software with Access Databases.  I have setup DFS on W2K3-R2 in all
locations.  Only one location is on use at a time, there is never anyone in
more than one location using any data.

I really need some help with replication. I have over 150 remote sites with
MSDE db's that I want to replicate back to our headquarters. I want to keep
each db separate but have them on one SQL 2005 server. I don't want to get
into details as to why I'm doing this because it ...

I got hit with a request yesterday that I need some basic advice on.
A customer wants to set up a database using SQL server (version not yet
specified - probably 2005) where they can download data to laptops, go out
into the field and update the data, and return to upload (update) ...

I have a situation where I have got an SQL Server 2005 Workgroup Edition
installed and two separate databases hosting business critical data. I would
like for both the databases to have a slave database into which our
developers could implement changes before applying them to the ...

Log Shipping has been set up and running for weeks.  I wanted to run counts
against the secondary server.  
I recovered the database (restore database ABC with norecovery).  This
allowed me to see the tables and run counts.  Now I want to get it back into

I have log shipping setup but the logs on the secondary server are being put
in the default data folder on the C drive.  My C drive is almost out of space
and I can't figure out how to move databases to the D drive.  
On my primary server the databases are store on the D drive

I'm setting up a merge subscription on SQLExpress to SQL2005. When applying
the initial snapshot, it is attempting to create a view before it creates the
table the view depends on. This is causing a
Microsoft.SqlServer.ComErrorException to be thrown with the message Invalid

We are using Merge replication under SQL Server 2005 SP2 using column
level tracking. We have a field which records the date-time that a
record is last edited.
This seems to be causing an issue because if two subscribers edit the

we are looking to get a reporting database for our needs instead of using
the prodution database. the provider of the application that is running on
this database server suggest to used a strore proc to copy the databases
tables to the reporting server. at our end we think that ...