Advertisement

06.08.2005 at 04:55AM PDT, ID: 21450721
[x]
Attachment Details

Replication: Disable Transaction Logging

Asked by paulop1975 in MS SQL Server

Tags: , ,

Hi, experts!

I'm implementing Transactional Replication with the following site configuration: 3 SQL Server Enterprise Edition Publishers and 1 SQL Server Enterprise Edition Subscriber. I will call the Publisher Servers 'Pub1', 'Pub2' and 'Pub3', and the Subscriber will be 'SubX'.
The Replication is intended to replicate all the tables in the 3 main databases on Pub1, 2 and 3 into one single database on SubX, therefore we use DTS to alter all the primary and foreign keys.
SubX is also the Distributor Server to try and minimize the traffic load during distribution, however we would like to tweak the process a little more and disable transaction logging (redo log and rollback as in Oracle DBMS) on SubX Server.
Is it possible to disable transaction logging on SQL Server 2000 EE? If so, how can one do it?

Thnx.

PauloStart Free Trial
 
Keywords: Replication: Disable Transaction Logging
Title
1 Oracle Replication
2 Multiple Transaction Rollback
3 Can you stop a Rollback?
4 Kill Rollback?
5 Rollback
6 Transactions and deleting records fro…
 
Loading Advertisement...
 
[+][-]06.08.2005 at 05:12AM PDT, ID: 14169843

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: transaction, sql, disable
Sign Up Now!
Solution Provided By: EugeneZ
Participating Experts: 3
Solution Grade: A
 
 
[+][-]06.08.2005 at 05:16AM PDT, ID: 14169870

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2005 at 08:50PM PDT, ID: 14196988

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2005 at 02:45PM PDT, ID: 14416629

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.12.2005 at 12:50AM PDT, ID: 14419233

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.12.2005 at 02:09PM PDT, ID: 14425660

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.14.2005 at 01:10PM PDT, ID: 14444746

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.15.2005 at 12:17AM PDT, ID: 14448312

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2005 at 05:41AM PDT, ID: 14465444

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32