SQL Error "UPDATE Backups SET BackupType = 1

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

SQL Error "UPDATE Backups SET BackupType = 1

Post by NYTECJ »

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.

Adrian (Softland)
Posts: 1940
Joined: Wed Dec 16, 2009 12:46 pm

Re: SQL Error "UPDATE Backups SET BackupType = 1

Post by Adrian (Softland) »


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