Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Error after login failure

Author  Topic 

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2007-01-16 : 08:59:31
Hi there SQL TEAM

We had merge replication running between a server and client.
Both using SQL 2005

Server 1 Publisher
Server 2 Subscriber

Server 1 connected to Server 2 [push subscription].
This morning I received the error below.

This was due to login failure [password expired]
Now when we try to start the replication again we get this.

The merge process was unable to create a new generation at the 'Subscriber'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994)
Get help: http://help/MSSQL_REPL-2147200994

• The transaction log for database 'MYDB_LVD' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases (Source: MSSQLServer, Error number: 9002)
Get help: http://help/9002

Server 1 log_reuse_wait_desc =NOTHING
Server 2 log_reuse_wait_desc =ACTIVE TRANSACTION

What could cause this problem
   

- Advertisement -