Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

REPLICATION PROD ISSUE ..Urgent .. please help

Posted on 2013-06-21
11
Medium Priority
?
275 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

886 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