.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

data is not replicating betwwwn two servers

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


we implemented replication between 2 servers.But from one week onwards master data is not replicating to another server.

All agents are running fine.From Repl monitor also we didn't find any error.When gone thru view synchronisatiuon status it is also running fine.

i am not able find exact root cause .can any one suggest me is there any root cause for this issue. 

View Complete Post

More Related Resource Links

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Reinitialize transaction replication clear the subcriber data and replicating again

Hi all, I add new table in to mu publisher database and reinitialize the subscriber.And i select the option to create new snapshot and marked as reinitialize.When it starts the reinitializing it clear all data from subscriber and coping again.Am i missing any thing here to add new table into existing replication ? Regards, Theesh

Collecting data from multiple servers

I have a list of about 500 servers that I am trying to connect to and collect various amounts of information from these servers through one query. I'd like to have something that doesn't involve OS batch scripting or using SQLCMD as the SQL Instances range from SQL 2000 through SQL 2008 R2. Does anyone have any suggestions or ideas on what to do to accomplish this?Big Ern

Import and Export data between servers


I hope this is the right place to ask.

I am conencting two different sql server with different IPs. I want to copy some of data from one server table to another server table. I saw from my friend there was Import and Export Data from Tools menu (he said that he added before), he wrote ips and then choose tables and columns ... I couldn't find this right now in Management Studio. Where is it? I anyone can help me, i will be appreciated.


I am using sql server 2005 standart edition



Ahmet UZUN

SQL Server 2008 R2 Data Collector for multiple servers.


Hello all,

I'm working as a intern and have been maintaining a performance monitoring application for my companies servers and wanted to know if "Performance Data Collector" could do the job for us(and that I've spent the last month working on...) I ran across an article(http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/ ) that seemed to describe this tool as pretty much what I've been working on.

Presently we do this:

1. Performance Monitor(perfmon.exe) logs all the performance counters we want and stores them locally on each server.

2. A client service(run on each server we monitor) takes the log files, zips them and periodically transfers them to the logging server.

3. Once on the logging server another service parses the files and bulk uploads them into a SQL Server 2008 R2 Database.

4. A SSAS cube on the logging server then processes all the data and we have our min/max/averages for the various counters.

Can I collect performance data from Windows 2008 servers that do not have SQL Server 2008/2008 R2 installed on them by using the server that is running the collector to pull the information? This would essentially b

Data transfer between two linked SQL servers



I need to build a service that copies new rows from SqlServerA.DB1.TABLE_X to SqlServerB.DB2.TABLE_X. Direction is from SqlServerA to SqlServerB

Source and destination tables are the same structure. SqlServerA and SqlServerB are located in two different cities and there is VPN connectivity between them. The VPN is based on Internet and reasonably fast.

The service need to be able to recover when VPN is down and try again later when VPN is running again.

I wonder if linked servers are suitable for this scenario? I can avoid joining distributed tables together and leverage linked servers by using INSERT statements.

I am aware of MERGE replication and I wonder if MERGE replication is a simpler alternative?

SQL Standard: Can we compress the data passed between linked servers?



I have to connect two sql server 2008 standard edition as linked servers. Is there any possible way to compress the data passed between two linked servers?

Thank you.

Data Encryption Between Two Sql Servers


Hi i need some help on this issue i am dealing with. I am trying to send and receive data between SQL server 2008 r2 installed on the server machine and another sql 2008 r2/other version installed on the client computer. What options do i have to have the data encrypted other than getting a SSL certificate from a trusted certificate authority. Please Let me know.


data replication between two servers on 2 different domains?



 I am doing transactional replication with updateable subscriptions between two servers (say A and B)
 These two servers are located in two different physical locations (say,LA and NY) and are also on different Domains(say domain X and domain Y).
 I think I need to have linked server set up between these two for data replication.
 could anyone suggest in how to set up the linked server between these two servers A, B for data replication?
Also, Is that the only way doing, or do you have anyother suggestions?


Replicating Only Objects, no data


I need to find a solution for having the same database objects on two servers without the data, and be able to synchronize them on demand.

Whenever a table changes (alter, create, delete) I need to be able to replicate those changes to the destination server without affecting its data.

If I add, alter or delete a stored procedure, or other objects such as functions, etc. I need to be able to see those changes on the destination.

any ideas.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend