SQL Error "UPDATE Backups SET BackupType = 1

Have questions about Backup4all, or having problems using it? Ask here for help.
Post Reply
NYTECJ
Posts: 3
Joined: Wed Jan 02, 2013 2:57 pm

SQL Error "UPDATE Backups SET BackupType = 1

Post by NYTECJ » Tue Apr 16, 2013 5:41 pm

Destination Type: FTP
Backup Type: Mirror
Receiving the following error in the logs:
SQL error "UPDATE Backups SET BackupType = 1 WHERE NOT (BackupType in (1,4)) AND BackupId = (Select Min(BackupId) from Backups)" - database is locked, database is locked (SQL81)

Jobs have been running successfully until recently. No changed were made. Tried restarting the server and SQL services to no avail.

Support
Posts: 1491
Joined: Wed Dec 16, 2009 12:46 pm
Location: Cluj-Napoca, Romania
Contact:

Re: SQL Error "UPDATE Backups SET BackupType = 1

Post by Support » Wed Apr 17, 2013 12:03 pm

Hi,

Please delete the backup job from Backup4all, then open the .bkc catalog file from the backup destination.
That will recreate the backup job in Backup4all.
Run again the backup.

Post Reply