Transactional Replication Issue



Hello,

I have not seen this before!

I am getting the following msg while I am trying to configure the
publication in a SQL 2005 SP2 Server.


-------------------------------------
Creating Publication

- Creating Publication 'test' (Error)
Messages
SQL Server could not create publication 'test'. (New Publication Wizard)

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

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

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

The current transaction cannot be committed and cannot support operations
that write to the log file. Roll back the transaction.
The current transaction cannot be committed and cannot be rolled back to a
savepoint. Roll back the entire transaction.
Changed database context to 'TTTState'. (Microsoft SQL Server, Error: 3930)

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


- Adding articles (Stopped)

- Starting the Snapshot Agent (Stopped)



The current transaction cannot be committed and cannot support operations
that write to the log file. Roll back the transaction.


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

Did anyone experience this before?

thanks,
Manoj Kumar
.



Relevant Pages

  • RE: Synchronisation failing on SQL CE Database
    ... There is also an error on the publication in the Replication monitor. ... Server SERVER, Level 0, State 1, Procedure sp_MSprepare_mergearticle, Line 78 ... I am having a problem setting up merge replication between SQL 2005 and SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Why is my _SERV_log.ldf file so big?
    ... take a look at the configuration in Enterprise Manager for your server. ... It's either on the server or on the databases themselves. ... you're doing then you should get your DBA to help with the SQL config. ... >> transaction log is turned on is to let it grow forever. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MSDE on flash memory
    ... Therefore you may end up corrupting the transaction log in top level but still have some "old" ... I was wondering if it is considerable for you to move the DB on a server? ... I don't think MSDE has any "embedded" specific integration including flash random writing or etc. Keep in mind that MSDE on XPE ... I don't think SQL CE has any flash related issues fixed either. ...
    (microsoft.public.windowsxp.embedded)
  • Re: SqlTransactions and Sql timeout errors
    ... Basically the way transactions work in SQL Server is that the first ... commit the transaction. ... In committing the transaction, the server ... For example, if an Update statement fails in a batch, then SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: List this publication in the Active Directory greyed out
    ... This should work if your server is registered in the domain. ... Looking for a SQL Server replication book? ... > publication using the Create Publication Wizard. ... > the active directory", but it's grayed out. ...
    (microsoft.public.sqlserver.replication)