Solved

REPLICATION PROD ISSUE ..Urgent .. please help

Posted on 2013-06-21
11
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

632 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