SQL Server - failure to replicate - Microsoft SQL Server

David Macken

After a recent crash, where tables had to be repaired we have been
unable to re-instate or create new merge replication from a MS SQL 2000
system. All old publications and subscriptions have been deleted. New
replications fail at the snapshot level. Anyone ideas ?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #1

Subscribe Post Reply

1666

Simon Hayes

David Macken <da**@dmacken.demon.co.uk> wrote in message news:<40*********************@news.frii.net>...

After a recent crash, where tables had to be repaired we have been
unable to re-instate or create new merge replication from a MS SQL 2000
system. All old publications and subscriptions have been deleted. New
replications fail at the snapshot level. Anyone ideas ?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I don't know much about replication, but if you can provide more
detailed information about the problem, someone may be able to help.
Can you give specific error messages to explain what you mean by "new
replications fail"? You might also want to post in
microsoft.public.sqlserver.replication, as you may get a better
response.

Simon

Jul 20 '05 #2

by: DTB | last post by:

I am having trouble creating an INSTEAD OF trigger in SQL Server to replicate a BEFORE UPDATE trigger from ORACLE. Here is a sample of the ORACLE BEFORE UPDATE trigger: CREATE TRIGGER myTRIGGER ON...

Microsoft SQL Server

Is there a SQL Server API to flush all buffers to disk?

by: SK | last post by:

I am looking for an API to flush all data in memory held by SQL Server to disk. Also, is there a tool for SQL Server like eseutil for Exchange that lets you correct a SQL database?

Microsoft SQL Server

is it good idea to replicate sql server db files?

by: jaekim | last post by:

Hi. I am wondering if it is a good idea to replicate sql server db files using frs. I don't really know how the frs works, so does frs replicates the whole database from time to time or just...

Microsoft SQL Server

Active Directory Error - The server is unwilling to process the request

by: microsoft | last post by:

Hi People, when I try to modify an active directory user programatically, I receive the following exception: The server is unwilling to process the request Reading the microsoft web site, I...

.NET Framework

Table Synchronization across databases on the same server

by: chandrub78 | last post by:

Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional...

Microsoft SQL Server

Repost: Replicate HTML InputFile control with Server controls

by: Paul Hobbs | last post by:

Hi All, I am trying to replicate the functionality of the HTML FileField control. I can use it just fine to prompt a user to browse to a file, and it retrieves the full path just fine. I can...

ASP.NET

any advice on how to replicate content across server farm

by: Jason Shohet | last post by:

Any 'best practices' advice from anyone, on how to replicate .NET sites across either 2000 or 2003 server (web edition) IIS boxes in a server farm? Copying files onto each server from my floppy...

ASP.NET

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...

Visual Basic .NET

replicate the GAC on win2003 server?

by: mg | last post by:

Is there a way to replicate the GAC on a win2003 server to another similar server? We are currently using DFS to replicate files, and I do not see how to use DFS to replicate the GAC. -- mg...

.NET Framework

Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote

by: aboutjav.com | last post by:

Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

SQL Server - failure to replicate

Similar topics