How can we help you today? How can we help you today?

Log Copy Queue Pending

Hello,
I just installed SQL Backup 6 and ran a full backup w/network copy last night and everything worked perfectly. I tried to setup transaction log backups this morning and the dumps ran fine, however, the logs are stuck in the Log Copy Queue and the "Last Attempt to Copy" column is empty. The log file for an individual database says:

"No attempts have been made to copy this file."

I am running backups every 15 minutes now and they are stacking up in the queue. Any thoughts/assistance is greatly appreciated. The server is an 64-bit cluster in case that helps any.

-Mike
mp
0

Comments

32 comments

Sort by
  • phegel
    brosato said:
    Here's what I did. It's working again.

    EXEC MASTER..sqbdata delete from backupfiles_copylist_log'
    EXEC MASTER..sqbdata 'delete from backupfiles_copylist'
    After I did this, I had to restart the SQL Backup Agent in the Services control panel.
    phegel
    0
  • Aleksandr
    I'm sorry for necroposting, but we are still expiriencing the same problem in our workspace when running transaction log backup for all databases in the server every 15 minutes. We have SQL Backup vesion 9.1.6.140 installed with MS SQL servers 2012 SP4 version 11.0.7001 and MS SQL 2008 SP3 vesion 10.0.5538. We have about 10-50 databases per one backup job per server. And this Log Copy Queue Pending problem happens randomly from time to time on different servers.
    What might be done to get rid of the problem?
    Aleksandr
    0

Add comment

Please sign in to leave a comment.