Solved

REPLICATION PROD ISSUE ..Urgent .. please help

Posted on 2013-06-21
11
268 Views
Last Modified: 2013-07-21
SELECT CAST(SUBSTRING(command, 7, 8000) AS NVARCHAR(MAX))
FROM msrepl_commands WHERE xact_seqno = 0x000F3AF20031F76E032C00000000 AND command_id = 96


while creating replication it's failing with error Transaction sequence number: 0x000F3AF20031F76E032C00000000, Command ID: 96

I ran above query and found the result as CSTAT

What does it mean and how to fix it?
0
Comment
  • 7
  • 2
  • 2
11 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39267425
What is the compatibility of the publisher and what is the compatibility of the subscriber?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267428
SQL version is 2005.

<<compatibility of the publisher and what is the compatibility of the subscriber>>
What does this mean and how to check?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267430
Acperkins:Aappreciate your help..We need to fix this ASAP.Kindly help

Please see the screenshot for the complete details.
Capture1.JPG
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39267449
What does this mean and how to check?
You use Google and you find and read and understand the following article:
ALTER DATABASE Compatibility Level (Transact-SQL)

Then you run the following query on the Publisher and all the subscribers:
SELECT name, compatibility_level
FROM sys.databases
WHERE name = 'YourDatabase'

If the answer is at least 90, then I have no idea what is going on.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267455
IT'S 90 -SQL 2005
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267462
Repliaction agent is running ...
Can we run post snapshot file separatelg? Is that possible?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267530
it seems someone has deleted the subscription... how to identify who has deleted it??
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39267629
how to identify who has deleted it??
Security.  Who has access to the server ? Simply recreate the subscription.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39268048
We have added the AD group.So by default only the member of the AD group. That's clearly understood.But I'm interested specfic member who has performed this action.
Is there a way to find it out?
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 total points
ID: 39268064
Unless you have activated a security trailing process, I am afraid that is not possible.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39268493
Can any one please confirm.. please...
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now