In version 10.1.10 of SQL Backup, Microsoft SQL Server Compact Edition (SSCE) was replaced with SQLite. This is the technology SQL Backup uses to store backup history.

This has the following impact:

• During the upgrade, the SQL Backup agent migrates as much of the latest backup history as possible in 15 seconds

• Older SQL Backup process activity may no longer be visible - if that is the case and you want to be able to see your full history you need to migrate it manually. You can use the sqbutility for that e.g:

  DECLARE @rows INT
  EXEC master..sqbutility 1001, 30, @rows OUTPUT
  SELECT @rows

• Users who generate their own reports using the sqbdata procedure may need to adjust to the SQLite syntax e.g:

  • LIMIT x instead TOP x,

  • text columns (e.g. database_name) are now case-sensitive etc

• Similar to the above, any user-created database objects in the SSCE database e.g. views, indexes, will need to be recreated in the SQLite database