Can Not Disable Replication In SQL7

Oct 24, 2000

Hi, guys

I have an urgent problem in replication.

Yesterday I set up a Transaction replication with 1 publication
Server A (publisher)(push)(SQL 7)
Server B (distributor and subscriber)(SQL 7)

The replication was succesful and the suscriber can get correct data.

This morning I found the Red sigh in replication mornitor/miscellaneous agents.The error message is:
"The job failed. Unable to determine if the owner (domain nameuser ID) of job Agent history clean up: distribution has server access (reason: Could not obtain information about Windows NT group/user 'domain name'. [SQLSTATE 42000] (Error 8198))."

I tried to use the 'disable publishing and distribution wizard' to disable this replication, but it did not finish and the screen jusr freeze. I used the task manager to end the task.

then I check the replication monitor, the publication was gone but the RED sigh still there.

I tried to use sp_dropdistpublisher to drop a Publisher
but it said "the server A is not a distributor"

I tried to use sp_dropdistributiondb to delete the distribution database.
but it said "Could not drop the distribution database 'distribution'.
This distributor database is associated with a Publisher."

I tried to use sp_dropdistributor to remove the Distributor .
but it said "Could not drop the Distributor 'Server B'.
This Distributor has associated distribution databases."

Any suggestion? Thank you in advance.

Theresa

View 2 Replies


ADVERTISEMENT

Disable Trans. Replication - HELP!

Mar 20, 2000

Hi,

I am trying to disable transactional replication, but am having some problems. I used the wizard, however, it has taken 7 hours so far and is still not done. SQL Server (7.0) is showing the connection as runnable but it seems as if nothing is being removed. Am I missing something? Should I have done something else before running the wizard? I can't even kill the SPID.

Can anyone help or offer some advice?

Thanks in advance...

View 1 Replies View Related

Temporarily Disable Replication

Jun 15, 2007

Is there a way to temporarily disable replication? My problem is that I have pull subscribers that I do not want accessing the database at certain times, so that data updates and backups can occur. Is there a way to make that happen?

View 4 Replies View Related

Why Replication On SQL7.0 Did Not Work

Mar 5, 2002

I set up the transationsal replication on SQL7.0. It did not work. Here are the messages

1 on Snapshot Agent: The process could not create file Server_namec$MSSQL7REPLdATAFTPServer_namefile_nam e. Error: Access is denied
2. On Log Reader Agent: bi replication transaction are available
3. Disribution Agent: The initial snapshot for publication "DB_Name" is not yet available.

Thank you for your help

View 2 Replies View Related

SQL7 Replication Thru Firewall

Dec 23, 2000

Hi,

Need to set up replication between a server in our corporate network and another outside our network. Both are NT 4 servers running SQL7 and I am instructed to configure merge replication on both ends. My questions are: Is it possible to achieve this by running tcpip(read somewhere that I would need to run MPR to load the net libraries) and configuring the firewall to allow tcp/ip on the ports we are running SQL on between the two servers?

Please help as this is very urgent.

Regards
Kunta

View 1 Replies View Related

SQL7.0 Merge Replication

Dec 10, 1999

I would like to set up one way Merge replication. The only way I was able to do this was to remove the triggers off the tables manually. There seems like there should be a better way.

View 2 Replies View Related

Problems With SQL7 Replication...

Mar 19, 2004

Trying to remove replication i get the error message..

Error 2812: Could not find stored procedure 'distribution.dbo.MSdrop_snapshot_dirs

Any idea ?

Thanks.

Andrew Ratley MCDBA.

View 4 Replies View Related

SQL Replication SQL7 And SQL2005

Nov 22, 2006

Hi there SQLTEAM

I have a situation; one of our clients requested us to start investigating SQL replication.

The Publisher would be the client's server running SQL7
And we would be the subscriber running SQL 2005

Can this be done?
Are there any pro's and con's on even trying replications between SQL 2005 and SQL7

If this is possible could someone be so kind as to point me to a step by step guide and how to achieve this.

View 1 Replies View Related

Why Transactional Replication Option Is Disable?

May 3, 2007

i read about what replication is and what are the types of replication but when i m trying to implement this i am unable to perform one of its type "Transactional Replication" i have no idea why this option is disable,can u plz guide me where i m wrong?

View 6 Replies View Related

SQL7/SQL2000 Replication. Auth Error

Aug 12, 2002

I'm attemting to replicate from a SQL7 box to SQL2000.

The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".

This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?

View 2 Replies View Related

SQL7/SQL2000 Replication. Auth Error

Aug 12, 2002

I'm attemting to replicate from a SQL7 box to SQL2000.

The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".

This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?

View 1 Replies View Related

Transactions Are Still Pending For Distribution After Disable Transactional Replication

Apr 11, 2007

Recently we disabled the transactional replication on a prodution database(data size:300GB) , two weeks later we were aware of the transaction log of that db almost reached the limitation (70GB).I investigated the issues and found:

1. open transactions pending for distribution:

DBCC opentran('xxxx')



Replicated Transaction Information:

Oldest distributed LSN : (0:0:0)

Oldest non-distributed LSN : (323830:7083:1)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.



2. exec sp_replcounters, got over 240,000 replicated_transactions, which caused the tran log extremely large.



The transactional replication has been disabled on this server, there are no publication, distribution DBs any longer, all replication-related agents are also gone, why did this still happen???



3. use sp_repldone manaully reset those 240,000 transactions to distributed, check opentran, it was fine for a while. The tran log file was freed up 99% after that.



4. check open transactions and run sp_replcounters today, found the over 60000 transactions again on the db.



Did anybody experience the same issue and knows how to fix this issue and stop this happening ?



Many Thanks,

Henry

View 4 Replies View Related

Help Needed Urgently! - SQL7 Replication Conflict Problem

Dec 18, 2001

Hi all,

i think i have serious problem. i have almost 20,000 rows with the following conflict on a table (generated by merge replication over a period of around 3 weeks) :

'The row was updated at 'SubscriberServer3.DatabaseA' but could not be updated 'at 'PublicationServer1.DatabaseA'. Metadata mismatch'

i have 20 remote subscribers & 1 publisher. The above message originates from practically everywhere.

Besides dropping(not practical at the moment) & recreating replication to get rid of them, what else can i do to resolve this problem?? Do i have to resolve this problem row by row?? i'm at my wit's end. Please help!!

Thanx in advance.

View 2 Replies View Related

Copy SQL7 To SQL7

Dec 5, 1998

How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.

View 6 Replies View Related

Can We Disable A Trigger In SQL 7.0

Jun 14, 2002

Is there a way to disable trigger for a time window and enable it when desired.

View 1 Replies View Related

Disable Trigger

Jul 12, 2001

Is it possible to disable a trigger to manually manipulate data without completely removing it? Thank you.

View 2 Replies View Related

Disable Identity

Oct 26, 2000

A quick question, how can I disable identity for the identity column
without dropping that column? Thanks!
Xiao

View 1 Replies View Related

Disable Logs

Aug 28, 2000

Is there a way to disable logging ?
I'm about to split a 1000000 rows table into three other tables , and would prefere not to log this action ...
Does anyone know how to do it in a SQL 7.0 statement ?

View 1 Replies View Related

Disable Triggers

Nov 21, 2001

I don't seem to be able to find a command to disable triggers. Can this
be done in SQL7?

Thanks.

View 1 Replies View Related

Disable Trigger

May 11, 2001

Is it possible to disable a trigger in SQL Server 6.5?
Is so, how can i do that?

View 1 Replies View Related

How To Disable Locking?!?

Apr 2, 1999

read-only option
dbo-use option
...

Anyone any ideas ?!?

View 3 Replies View Related

Disable Trigger

Oct 25, 2004

Hi,

can I disable a trigger in Sqlserver 2000??? When i run a store procedure who works with one table i want that the trigger doesn´t work it. After that the trigger would be enabled again.

I know i can delete it and create it again but something like "ALTER TRIGGER DISABLED" would be ok.

Thanks.

View 6 Replies View Related

Disable Trigger

Mar 23, 2004

Sorry, may be it is very simple, but
how can I disable all trigger on a tabled under sql 2000

View 3 Replies View Related

SQL 2012 :: CDC Is Disable

May 20, 2014

CDC is disabling when we do bulkinsertsupdateschange schema .how to findout why CDC disabled and how to prevent it ?

View 3 Replies View Related

Is There Any Way To Disable The Primary Key ..?

Feb 24, 2007

Hi,

Is there any way to disable the primary key constraint?.I want to move the records from one table to another.say column 'x' in the source table doesnt contain a primay key.But my target table column 'x' contains primay key.
How to ovecome this problem?
Thanks in advance

View 2 Replies View Related

Disable Indexes

May 30, 2007

Hello all.

Could anyone advise me how to disable indexes on a specific table at the start of a script, then re-enable them at the end?

Thanks all.

View 5 Replies View Related

Disable DatabaseMail90.exe

Feb 28, 2008

I am looking for a way to disable DatabaseMail90.exe (temporarily) while still allowing emails to queue up.

At first, I thought the solution was sysmail_stop_sp... but if I use this... calls to sp_send_DBMail fail with the following message:

Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.

I'd like the emails to be queued... I just want to postpone sending them. Anyone know how to do this?

- Alan D. Nelson

View 2 Replies View Related

Is It Possible To Disable All Restrictions On A Ms Sql DB?

Jul 20, 2005

In meen. primary keys, NOT NULL, IDENTETIES...et.cI have to do a maunally, one time, building of a database. Sometables has tostay an some are to be exchanged. The foreignkey inforcemnt ill do for myself so everything is correct. I just need to be allowed to de thede taskfor a while. Is it impossible?RegardsAnders

View 1 Replies View Related

Not Able To Disable Users

May 6, 2008

I am trying to disable certain users, but it is giving me this error. I am able to disable some accounts, but not all of them. It seems to happen with user that have been recently created.


TITLE: Microsoft SQL Server Management Studio
------------------------------

Disable Login. failed for Login 'domainuser'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Disable+Login.+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not obtain information about Windows NT group/user 'domainuser', error code 0x5. (Microsoft SQL Server, Error: 15404)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15404&LinkId=20476


The links lead to a page that is no longer available.

I read somewhere that it had to do with the SQL Server service account and that if you change it to a Domain Administrator it would and it does, but I can not believe the solution. I would say that this even started happening after we applied SQL 2005 Service Pack 2.

Has anyone else seen this problem. Do I really need to make it a Domain Administrator?

Thanks

View 1 Replies View Related

Disable Sql Authentication

Apr 29, 2008

what is the disadvantage to disable sql authentication, what is it different from window authentication

View 4 Replies View Related

Trigger Disable

Aug 9, 2007

Sorry to reopen a post, but I'm having the same problem. Worse, I can't change the trigger code right now.

My concerns with disabling triggers are:

1) DISABLE TRIGGER affects all sessions, not just the session doing the mass load
2) DISABLE TRIGGER is permanant until re-enabled, so if the mass load process fails (and if our TRY/CATCH blocks aren't perfect), then the triggers would remain disabled for normal OLTP use.
Any ideas on ways around this? I can identify all the work the triggers would have done and do it on my own. The problem is getting them not to do it!

View 9 Replies View Related

Disable Grouping

Aug 20, 2007

I would like to be able to disable grouping depending on the value of parameter. At the moment I have the following expression for grouping:
=IIf(Parameters!Group2.Value.equals(""), false, Fields(Parameters!Group2.Value).Value)

What I am trying to do is if the value of the Group2 parameter = "" turn off grouping. Group2 is assigned a value from the following custom code:

Function Group2Value() As String
Dim Group As String
Group = ""
Select Case Report.Parameters!ReportType.Value
Case "1"

Group = ""
Case "2"

Group = "CategoryID"
Case "3"

Group = "StockFamilyID"
Case "4"

Group = "GroupID"
Case "5"

Group = ""
Case "6"

Group = "SaleableGLCodeID"
End Select
Return Group
End Function

However this is not working.

Can grouping be disabled and if so what am I doing wrong?

Thanks in advance.

View 3 Replies View Related

Disable Filter

Nov 11, 2006

i am having a query in front end like this..

func()

select * from table where cond1 and cond2 and col.port in <string> ... goes

end

i passing this string from other function, i may be not be needing this filter(underlined) for some functionality, but i will be using the same function for both the functionalities

i need a string that should tell the sql server to allow all the possible values for that column, so by disabling the filter which i am using...

pls tell me URGENT
Thanks in advance

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved