Error 166
crimdon
Posts: 54 Bronze 3
When I backup a particular database, I get the following error:
Warning 166: Failed to delete old entries in local history tables: OLEDB error running ExecFast command: DELETE FROM backupfiles_copylist_log WHERE copylist_id < 312008 (The lock manager has run out of space for additional locks. This can be caused by
large transactions, by large sort operations, or by operations where SQL Server Compact Edition creates temporary tables. You cannot increase the lock space. []
).
SQL Backup exit code: 166
The backup works fine but it dosen't write the datbase last backed up back to the database.
Regards
Andrew Lackenby
Warning 166: Failed to delete old entries in local history tables: OLEDB error running ExecFast command: DELETE FROM backupfiles_copylist_log WHERE copylist_id < 312008 (The lock manager has run out of space for additional locks. This can be caused by
large transactions, by large sort operations, or by operations where SQL Server Compact Edition creates temporary tables. You cannot increase the lock space. []
).
SQL Backup exit code: 166
The backup works fine but it dosen't write the datbase last backed up back to the database.
Regards
Andrew Lackenby
Comments
EXEC master..sqbdata 'SELECT COUNT(*) FROM backuphistory'
EXEC master..sqbdata 'SELECT COUNT(*) FROM restorehistory'
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
I get 30947 and 19 from those queries
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 25000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 50000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 75000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 100000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 125000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 150000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 175000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 200000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 225000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 250000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 275000'
EXEC master..sqbdata 'DELETE FROM backupfiles_copylist_log WHERE copylist_id < 300000'
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8