We just released SQL BAK Explorer 2.0 today, and the significant addition is that of a Query Window.

As some of you may know, SQL BAK Explorer stores backup details of the files it reads in a SQL Server Compact database.  There are 5 tables used to store the details i.e.

  • backupset
  • backupmediaset
  • backupmediafamily
  • backupfile
  • backupfilegroup

The structure of these tables are similar to the same tables found in the msdb database, so if you’ve ever queried for backup details in msdb, you’ll feel right at home here.

So in the Query Window, you simply enter a query to retrieve the backup details you want e.g.

If you want to return multiple result sets, end each query with a semi-colon, and start each query on a new line e.g.

The SQL syntax for SQL Server Compact is fairly similar to the SQL Server syntax, so if you are already familiar with SQL Server query syntax, writing for SQL Server Compact should be easy.

Leave a Comment

Your email address will not be published. Required fields are marked *