Post reply

Backup Log Error,Pls help

  • June 27, 2005 at 11:39 pm

    #87992

    My company's SQL Database log is too big, I executed T-SQL"Backup log databasename with no_log".it prompted"The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed."

    The SQL Server is a Subscription server,NOT A PUBLISHER SERVER.I can't use sp_repldone.Now,what can I do?

    Thanks!

  • June 28, 2005 at 12:43 am

    #568824

    It sounds like this database is using transactional replication.

    Check and make sure that this process is running sucessfully by the sounds of thinks

    it's not. You might want to find out why the replication is not working.

    If you can't resolve it then I might suggest that you remove replication (script before removing), backup database and log, shrink log file and then try recreate replication.

    Hope this makes sense and helps.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply