2

Is the structure of SQL Server database backup BAK file similar to NTBackup BKF file? Is there any reference which can be redirected to understand the difference between NTNAckup and SQL Server Backup (*.bak) files?

Lukasz Lysik
  • 10,462
  • 3
  • 51
  • 72
user249205
  • 21
  • 1
  • 2

2 Answers2

2

No, the SQL format and the NT format have absolutely nothing in common.

For an overview of SQL Server backup semantics, see Backup Overview (SQL Server).While the NT backup format is documented at NT Backup File and there is an API for access, the SQL's backup format is undocumented and the only access API is via the T-SQL BACKUP and RESTORE statements. The SQL backups (format, semantics, API) long predates the existance of NT as an operating system.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
1

According to the answer How to read the meta data out of SQL Server backup files directly? the .bak file is a Microsoft Tape Format file. Here's a PDF that contains the format.

And here is documentation for NTBackup File https://msdn.microsoft.com/en-us/library/dd305136.aspx

Community
  • 1
  • 1
Igor Kudrin
  • 185
  • 5