asked on

Integrity test of a BAK dump mS SQL file

Hello

I need to test the integrity of a dump file of MS SQL server (*.BAK file)

Is there a simple command (or a free tool) that could check that this file is OK and not corrupted? Ans that restoration to an SQL server will be OK?

I do not have SQL Server installed and I am looking for an external tool (without having to import the BAK file in SQL)

Thank you for your help

Pavel Celba

The only workable solution is to restore the .bak file.

Formerly existing tools were discontinued already:
https://www.red-gate.com/products/dba/sql-virtual-restore/
https://blog.apexsql.com/apexsql-restore-discontinued/

Of course, if yo are looking for a free tool then you may still use SQL Server Express or SQL Server Developer.

ste5an

Is there a simple command (or a free tool) that could check that this file is OK and not corrupted? Ans that restoration to an SQL server will be OK?

The only way to be 100% sure is to restore it on SQL Server instance and run DBCC CHECKDB on it immediately.

The next best way is to run BACKUP VERIFY ONLY. But this is only good, when the backup was created WITH CHECKSUM. But even then it may be not corruption free.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.