Solved

REPLICATION PROD ISSUE ..Urgent .. please help

Posted on 2013-06-21
11
271 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create a Calendar table 29 44
I have an unknown large SQL database I want to get rid of 10 45
t-sql left join 2 34
sql server query 9 26
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

738 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