Tagged Questions
0
votes
1answer
20 views
Synchronizing two SQL Server Instances
I have two network segments and both are connected using the internet, say one as corporate server and another as remote production. I have an Intranet application running in both environments using ...
0
votes
1answer
31 views
What's the best way to create a dev version of a SQL Server database?
I just inherited a project from someone else, and I was wondering whether there's an easy way to identify all of the relationship dependencies in a DB so that you can easily delete a bulk of the data ...
0
votes
1answer
39 views
distribution.dbo.MSdistribution_history comments explanation
The comment column of distributor.dbo.MSdistribution_history contains comments such as
<stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880">
...
0
votes
0answers
14 views
MSSQL Master-Master replication [migrated]
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
0
votes
0answers
75 views
Deadlock between select WITH (NOLOCK) and replication agent
I experienced a deadlock between the database replication agent and a select statement that uses the nolock hint. The select statement was chosen as the victim. Here is the select statement, and as ...
-1
votes
1answer
53 views
How to Replicate a SQL Server 2005 Database File (MDF)
I am Developing a Database Program in Client/Server Basis. I Started the Server by TcpListener class (C#) . The Clients will be connected and Query from clients will be executed in the server side mdf ...
0
votes
0answers
28 views
SQL Server Replication - best way to get last_distsync?
We're trying to find out when subscriptions are hanging and falling out of date due to desktop heap issues. The best way we've seen is by using last_distsync, gotten from running
...
1
vote
1answer
165 views
SQL Server Replication issues
I'm trying to set database snapshot replication using c# with SQL Server 2008 R2. when I'm connecting to the server everything goes as it should... but after the following lines of the code:
...
0
votes
1answer
111 views
Firebird database replication to ms sql server
We have an firebird database connected to our access control system and then a separate web app that I developed for our time and attendance using sql server 2005 as the data source.
I wanted to use ...
0
votes
2answers
376 views
Replicating all views, procs, and functions in SQL Server 2008
I have a SQL Server 2008 instance set up with replication. When we do a deployment, I want to make sure that all views, procs, and functions are replicated to the replica. This means that if I add a ...
2
votes
0answers
307 views
SQL Replication 'The process could not connect to Subscriber'
I have three servers, all Windows 2008 + SQL Server 2008 R2:
Server 'A'
Server 'B'
Server 'Z'
A and B are publishers, Z is a subscriber to both A and B. The subscriptions are configured in 'Push' ...
0
votes
1answer
282 views
Pause SQL server replication temporarily
We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber.
We have an activity to change the location of the replicated DB ...
0
votes
0answers
40 views
Merge Replication excessive traffic [closed]
We currently have about 10 sites that uses the push merge replication model to sync to a central location.
Network administrators have picked up about 2GB of up and down stream traffic between each ...
2
votes
3answers
287 views
Sql Server sync alternatives
We have two Sql 2008 R2 database. First and main one is on-premise which is used by our stock management and accounting systems.
The second is for our web site and it is on a 3th party hosting firm ...
1
vote
2answers
160 views
Script to replicate SQL Server data dynamicaly
I have an access 2010 application with a SQL Server database.
But I need to do an offline version. So I thought I would create a local SQL Server database on their computers then they can run a ...
