Open SQL Server backup files in your browser

The .bak file SQL Server writes when it backs up a database. Look inside one right here, every table and row, without a SQL Server to restore it to. Nothing leaves your device.

Or drop it anywhere on this page

What you'll see

Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.

Sales_full.bak

SQL Server backup • Compressed • 24 tables • 96.2 MB

  • Every table and view in a folder • Rows counted
  • Keys lead to the rows they point at
  • Search • Every table at once
  • Export • Save a table or the whole database

About SQL Server backup

SQL Server's BACKUP DATABASE writes a whole database into one file, usually named .bak: maintenance plans, hosting panels and the apps that carry SQL Server Express make them every night. Putting one back takes a SQL Server as new as the one that made it, and a restore.

A full backup is the database's pages as its data files keep them, wrapped in Microsoft Tape Format, the layout NTBackup wrote too, and from SQL Server 2008 on it can be compressed in chunks. A differential backup holds only the pages changed since the last full one, and a log backup, often a .trn, only the log.

Filepeek finds the pages in the backup itself, a compressed one unpacked a chunk at a time in your browser, and opens the database as a folder of its tables, each in a grid to sort, filter and search. Export saves a table or the whole database as a SQLite file, a SQL dump or one Excel workbook. A differential or log backup shows what it is on its About card.

SQL Server database backup

Format

MIME type
application/octet-stream
Made by
Microsoft, for SQL Server
Released
1998

Inside the file

Holds
A database's pages
Wrapped in
Microsoft Tape Format
Compression
Optional, in chunks
Kinds
Full, differential and log

Opens in every browser

Filepeek opens SQL Server backups, compressed or not, in Chrome, Edge, Firefox and Safari. On their own, browsers only download them, and only a SQL Server restores them.

  • YouChromeOpens through Filepeek
  • YouEdgeOpens through Filepeek
  • YouFirefoxOpens through Filepeek
  • YouSafariOpens through Filepeek

Apps that open SQL Server backup

  • WindowsSQL Server Management Studio, which restores it to a SQL Server
  • MacSQL Server in Docker, which restores it
  • iPhone and iPadNo app opens it
  • AndroidNo app opens it

Questions

How do I open a SQL Server .bak without restoring it?

Drop it on this page or choose Peek a SQL Server backup. The database inside opens as a folder of its tables, each with its rows counted, and the one you pick opens as a grid, with no SQL Server to set up.

Does it open compressed backups?

Yes. A backup made WITH COMPRESSION, as SQL Server 2008 and later write it, is unpacked a chunk at a time in your browser, so a big one opens without unpacking it all first.

Why doesn't my differential or log backup open?

A differential backup holds only the pages changed since the full backup before it, and a log backup only the log, so neither holds the tables on its own. Open the full backup they follow.

How do I restore it in SQL Server?

In SQL Server Management Studio, right-click Databases, choose Restore Database and pick the .bak as its device. A backup only restores to a SQL Server as new as the one that made it.

Can I get my data out as Excel or CSV?

Yes. Export saves the table on show as CSV, Excel, JSON or Parquet, and every table at once as a ZIP of CSVs, one Excel workbook with a sheet for each table, a SQLite database or a SQL dump.

Does an encrypted backup open?

No. A backup made WITH ENCRYPTION, or of a database with Transparent Data Encryption, is locked with a certificate only its SQL Server holds, so it doesn't open here.

How do I send a large SQL Server backup?

Most email stops at 20 to 25 MB. To send the whole file, upload it to Fileport and share the link. Your SQL Server backup arrives unchanged, and your recipient can start downloading before the upload finishes. It is free up to 20 GB with no account. You can also choose Send via Fileport here, which hands the open file over in a new tab.

More data formats

All supported file types

Tell us what happened

Where the file came from helps us most

With itNever the file or its name
Thank you

Opens in a new tab

Keys

Everywhere

EXIF

Verify

License

Signature