English
日本の
PCVITA software to repair corrupt SQL Server BAK files
SQL BAK File Repair Tool
PCVITA SQL BAK File Repair Tool repairs corrupt and damaged SQL Server backup files from SQL Server 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000. SQL backup recovery software reads BAK files of any size and previews tables, views, stored procedures, functions, rules and triggers. Red marks every deleted record. You export the recovered data to a live SQL Server database, script files or CSV. Free demo exports 25 records of every table.
- Input
- Corrupt SQL Server BAK files, single or several, any size
- Output
- Live database, script file or CSV file
- Recovers
- Tables, views, procedures, functions, rules, triggers and keys
- Preview
- Deleted records and objects in red before you export
Also recovers database files stored in the backup, supports XML data type and Unicode stored procedures and exports structure alone or structure with records. See all features. For a damaged MDF file with no backup, open the SQL Database Recovery Tool.
How BAK Repair Software Recovers Data From a Corrupt Backup
Your damaged BAK file goes in on one side. Recovered tables, views and procedures come out on the other, as a live database, scripts or CSV files.
Corrupt SQL BAK File
SQL Server 2000 to 2019 backups
- Backups that fail to restore
- Single BAK files or folders of them
- Files of any size, tested up to 1.4 TB
PCVITA SQL BAK Repair Tool
Works on your Windows machine
- SQL Server version detected for you
- Deleted objects shown in red
- Database files inside the backup recovered
Recovered SQL Data
Three export options, from live database to CSV
- Structure alone or with records
- Selected tables, views and procedures
- Deleted records exported on request
- 1LoadBrowse to a damaged BAK file or a folder of them.
- 2RecoverScan the file and preview tables, views and deleted objects.
- 3ExportSave the recovered data as a database, scripts or CSV.
Repair a Corrupt SQL Backup File in 6 Steps
Six screens of the BAK file repair software from the first click to the exported database. Select any step to view its screen. Read the full walkthrough in the Software Guide.
Step 1. Open the Software
Install PCVITA software on a Windows machine, then select Start, All Programs and SQL Backup Recovery. Keep SQL Server installed on that machine so you can import the recovered database later.
Step 2. Load the Corrupt BAK File
Click Browse to load the BAK file. Select the corrupt backup file in the dialog and click Open.
Step 3. Detect the SQL Server Version
Choose the auto detect option to let the software read the SQL Server version of the .bak file. Select the version by hand if you prefer. Load several backups with Multiple Backup Files, then choose Autodetect or Let me choose, add files or a folder and click OK.
Step 4. Select the File and Click Recover
Select the backup file and click Recover. SQL BAK repair scans the file, shows the scan progress and loads the result. Click Close when the scan ends.
Step 5. Preview Recovered and Deleted Objects
Browse the recovered tables, views and stored procedures in the preview. Deleted database objects show in red. Open the deleted stored procedures, rules, functions, triggers and views one by one before you export.
Step 6. Export the Recovered Data
Click Export and select SQL Server Database, CSV File Format or SQL Server Compatible SQL Scripts. For a database export, select the authentication type, create a new database or use an existing one and tick the components. Select With Only Schema or With Schema & Data. Tick the deleted records option to include them, click Save and check the result in SQL Server.
Free demo needs no licence and previews every recovered object.
SQL Backup Recovery Software Features
What PCVITA BAK repair software does for SQL BAK file recovery, grouped by task.
Repairs Corrupt SQL BAK Files of Any Size
Damaged backup files load in one step for SQL file recovery, single or in batches, however large they are.
Repair Corrupt SQL Server Backups
Corrupt and unhealthy BAK files from SQL Server 2000 to 2019 load, scan and give back tables, views, rules, triggers, functions, keys, columns and indexes.
No BAK File Size Limit
BAK files of any size load, up to terabytes. Testing covered a 1.4 TB file.
Load Several BAK Files Together
Select Multiple Backup Files, then let the software autodetect the files or choose them yourself with Add File or Add Folder.
Auto Detect the Backup Version
SQL BAK repair reads the version of the backup file for you. Select the version by hand if you prefer.
Recover MDF, NDF and LDF Files
Database files stored inside the BAK file come back with the backup details intact.
Recovers Deleted Objects and Database Structure
Deleted data comes back marked in red with the database structure in place.
Deleted Tables and Records in Red
Preview shows deleted SQL table records and deleted database objects in red before you export.
Deleted Procedures, Functions, Views, Rules and Triggers
SQL data recovery covers deleted stored procedures, functions, views, rules and triggers. You open them one by one.
Primary and Foreign Keys Included
Keys, columns and indexes return together with the tables that own them.
Unicode Procedures and XML Data Type
Unicode stored procedures recover. XML data type is supported in SQL Server 2019 down to 2005.
Previews Every Object Before You Export
Check the recovered data on screen and decide what to save.
Preview Tables, Views and Procedures
SQL BAK repair loads the items of the backup after the scan and shows the data inside them.
Preview Deleted Views, Rules and Triggers
Deleted objects open in their own previews, so you see what a deleted view, rule or trigger held.
Select Only What You Need
View tables, triggers, procedures or views and export only the items you select.
Check Before Anything Reaches SQL Server
Preview loads inside the software window, so you review the data before an export begins.
Exports to SQL Server, Scripts or CSV
Recovered data goes straight into a live database or into files you restore later.
Export to a SQL Server Database
Choose Windows or SQL Server authentication, then create a new database or export to an existing one.
Export as Compatible SQL Scripts
Save the data as a script file and restore it on SQL Server later.
Export to CSV File Format
Save the selected tables with schema and data as CSV and keep the export detail in a .csv file.
Structure Alone or With Records
Export the structure of tables, views and procedures alone or add the records.
Export Deleted Records on Request
Tick the deleted records option to add deleted data and deleted objects to the output.
See these options on your own backup. Free demo previews every recovered object.
Why RESTORE Alone Cannot Fix a Corrupt SQL Backup File
Four limits of SQL Server restore checks on a BAK file that Microsoft documents, with what PCVITA does instead.
- 1
VERIFYONLY Skips the Data Structure
Microsoft states that RESTORE VERIFYONLY confirms the backup set is complete and readable. VERIFYONLY does not attempt to verify the structure of the data in the backup volumes. PCVITA tool opens the data itself and previews every recovered object.
- 2
Restore Stops at the First Error
RESTORE stops on the first error by default. Invalid checksum ends the restore with an error report. PCVITA tool scans the full BAK file and lists what it recovers.
- 3
CONTINUE_AFTER_ERROR is a Last Resort
Microsoft advises restoring an earlier backup without errors first. Restoring a damaged backup with CONTINUE_AFTER_ERROR comes last, as an attempt to salvage data. No clean copy left? PCVITA tool recovers objects from the damaged file.
- 4
Optional Checksums Leave Gaps in Verification
Backup checksums are optional because they add overhead. Without one, restore and RESTORE VERIFYONLY proceed without any verification. Preview in PCVITA tool lets you check the data before an export.
Prepare Before You Repair a SQL BAK File
Seven checks before the first BAK file repair. Check them off, then open the software.
- Copy the damaged BAK file to a safe folder and load the copy, so the original stays untouched.
- Install Microsoft .NET Framework 3.5 on a Windows machine with 100 MB free disk space and 4 GB RAM recommended.
- Open the software with Run as Administrator on Windows 10, 8.1, 8, 7 or Vista.
- Install SQL Server on the machine if you plan to move data into a live SQL Server database.
- Keep your login details ready, either Windows authentication or the SQL Server name, user and password.
- Choose the database name before you export. Use a new name that is not in use. Otherwise select the existing database that receives the data.
- Try the free demo on your BAK file before you pay. Download the PCVITA SQL Backup Recovery demo and preview every recovered object.
Hardware and Windows lines match the Specifications table below.
SQL BAK Repair Software Pricing
Start with the free demo and buy one licence when the preview matches your needs. Full edition removes the export limit.
Demo Edition
Free
Preview every recovered object, export 25 records per table
- Export limit25 records a table
- PreviewAll objects
- LicenceNot needed
Version 12.0, 18.40 MB, Windows
Full Edition
$149 one licence
Export every record from every BAK file you load
- Export limitNone
- PreviewAll objects
- DeliveryBy email
30 Days Money Back*, Safe & Secure checkout
Included in the full edition Every option below works without the demo export limit
- Backups From SQL Server 2019 to 2000
- Several BAK Files at Once
- Preview of All Recovered Objects
- Deleted Objects Shown in Red
- Structure Alone or With Records
- Export to a Live Database
- SQL Script Files and CSV
- No BAK File Size Limit
SQL BAK Repair Tool Specifications
System needs and BAK file repair limits at a glance.
| Version | 12.0 |
|---|---|
| File size | 18.40 MB |
| Windows versions | Windows 11 (64 bit), 10, 8 and 7 (32 and 64 bit), Windows Server 2025, 2022, 2019, 2016, 2012 R2 and 2008 |
| Prerequisite | Microsoft .NET Framework 3.5 |
| Hardware | Intel Core 2 Duo E4600 2.40 GHz processor, 4 GB RAM, 100 MB free hard disk space |
| SQL Server | Installed on the machine for a live database export |
| Free demo limit | Preview of all recovered objects, export of 25 records for every table and 5 other categories |
| Delivery | Electronic delivery by email after payment confirmation |
| Input files | Corrupt SQL Server BAK files, single or several, with no file size limit |
|---|---|
| SQL Server versions | 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000 |
| Objects recovered | Tables, views, stored procedures, functions, rules, triggers, keys, columns and indexes |
| Deleted data | Deleted records and objects shown in red, exported on request |
| Output formats | SQL Server database, SQL Server Compatible SQL Scripts and CSV |
| Export modes | With Only Schema or With Schema & Data |
| Authentication | Windows or SQL Server login for a database export |
PCVITA BAK Repair vs SQL Server RESTORE Statements
Microsoft restore statements set against PCVITA tool, with the points that matter for a damaged backup.
| Point | RESTORE Statements | PCVITA Tool |
|---|---|---|
| What it checks | RESTORE VERIFYONLY confirms the backup set is complete and readable | Opens the BAK file and previews objects and data |
| Data structure | VERIFYONLY does not verify the structure of the data | Scan lists tables, views and triggers |
| On errors | RESTORE stops at the first error by default | Recover scans the file and previews what comes back |
| Salvage option | CONTINUE_AFTER_ERROR continues if the corruption permits, as a last resort | Recovers objects from the damaged file, then exports them |
| Backup details | HEADERONLY and FILELISTONLY list backup sets and logical files | Reads the backup version and loads the BAK file |
| Output | Restored database on a SQL Server instance | Database, scripts or CSV files |
| Price | Included with SQL Server | Free demo, full edition $149 |
RESTORE facts come from RESTORE VERIFYONLY (Microsoft Learn) and RESTORE Arguments (Microsoft Learn). Checksum facts come from Possible Media Errors During Backup and Restore (Microsoft Learn). Facts about the tool come from the Specifications table and the Features section.
Backup Checks Before You Blame Corruption
- Use RESTORE VERIFYONLY for a completeness and readability check of the backup.
- VERIFYONLY checks the checksum only if one is present on the backup media.
- Backup checksums are optional because they add overhead to the backup job.
- Without a backup checksum, restore proceeds without any verification.
- Try an earlier backup first. Microsoft names CONTINUE_AFTER_ERROR the last resort for a damaged backup.
Open the Software Guide for the export options that move recovered data into a new database.
Sources for SQL Backup Facts Microsoft pages behind the limits on this page
- Microsoft LearnRESTORE VERIFYONLY
- Microsoft LearnRESTORE Arguments
- Microsoft LearnPossible Media Errors During Backup and Restore (SQL Server)
SQL Backup Repair FAQs
Questions about BAK file repair, grouped by topic.
Working and limits What happens during the repair
How does PCVITA repair a damaged SQL backup?
Six steps repair a damaged BAK file.
- Step 1. Open PCVITA software from All Programs.
- Step 2. Click Browse, select the damaged BAK file and click Open.
- Step 3. Let the software read the version or select it yourself.
- Step 4. Select the file and click Recover.
- Step 5. Preview the recovered and deleted objects.
- Step 6. Click Export and select a database, CSV or script export.
Can SQL recovery software repair a BAK file that will not restore?
Yes. PCVITA software scans a corrupt backup file and loads the tables, views, stored procedures and other objects it recovers. Preview them first, then export to SQL Server, scripts or CSV.
Does the tool recover deleted tables and records from a BAK file?
Yes. Deleted table records and deleted database objects show in red in the preview. Tick the deleted records option on the export screen and they join the rest of the data.
Is there a size limit for the BAK file?
No. SQL BAK repair places no limit on BAK file size. Testing covered a 1.4 TB backup file.
Can I repair several BAK files together?
Yes. Choose Multiple Backup Files, then Autodetect to find the files or Let me choose to select them. Use Add File or Add Folder, click OK and load the batch.
How do I know that my SQL backup file is damaged?
Check it with RESTORE VERIFYONLY. Microsoft says the statement confirms the backup set is complete and readable. VERIFYONLY does not verify the data structure. Any restore that stops with a checksum error points to damage as well.
Does the software recover MDF, NDF and LDF files stored in a BAK file?
Yes. PCVITA software recovers the MDF and NDF files inside the backup and the LDF files that go with them. Backup details stay intact.
Demo and price Demo limits and the full edition price
What does the free demo of PCVITA SQL Backup Recovery do?
Demo edition previews everything and limits the export. You load BAK files, scan them and preview every recovered object, with deleted ones in red. Export stops at 25 records in every table and 5 other categories.
What does the full edition cost?
$149. Full edition removes the demo export limit and comes with a 30 day money back guarantee. Your copy arrives by email after payment.
Compatibility and exports SQL Server and Windows versions, authentication and export modes
Which SQL Server versions does the BAK repair tool support?
SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000. PCVITA software detects the backup file version. Select the version by hand if you prefer.
Which Windows editions does the BAK repair software support?
Windows 11 (64 bit), 10, 8 and 7, plus Windows Server 2025, 2022, 2019, 2016, 2012 R2 and 2008. PCVITA software needs Microsoft .NET Framework 3.5, 100 MB free disk space and 4 GB RAM recommended.
Do I need SQL Server installed to repair a BAK file?
Yes, for a live database export. Install SQL Server on your machine before you start, then choose either authentication type on the export screen.
Does the BAK repair software work on a Mac?
No. PCVITA software is a Windows application. Install it on a Windows machine instead.
Can I export only the schema of tables and views?
Yes. Select With Only Schema to create the structure of tables, views and procedures. Select With Schema & Data to export the structure and the records together.
Does the repair cause any data loss?
No. No data loss issue is linked with PCVITA software. Data keeps its original form during export. Preview lets you check it first.
Need an answer that is missing here? Ask on Live Chat or send a note from the Contact Us page.
Customer Reviews of SQL Backup Recovery
Star ratings from pcvita.com users and written reviews of SQL BAK file recovery.
With SQL bak file repair tool, I was able to recover and export my corrupt .bak file into SQL Server in just a few clicks. The software is having an easy-to-use interface and is integrated with numerous features. Thanks for developing such an amazing utility.
SQL Backup Recovery is a reliable and smart solution to recover backup file data like tables, views, procedures, triggers etc. from the corrupt/unhealthy SQL bak file. Moreover, it is also capable to recover .bak file of any file size which is amazing. An Excellent utility!.
GearDownload: clean software badge, with no spyware, adware or viruses found in PCVITA products.
DownloadAtoZ: 5 star award badge for PCVITA products. All badges sit on the PCVITA awards page.
Key Takeaways on Repairing SQL BAK Files
Short version of this page on SQL BAK file recovery.
- Files and versions. PCVITA software repairs corrupt BAK files of SQL Server 2000 to 2019, single or several, with no size limit.
- Deleted data. Deleted records and objects show in red in the preview. You export them on request.
- Preview and export. You review tables, views and procedures first, then export to SQL Server, scripts or CSV files.
- System needs. PCVITA software works on Windows with .NET Framework 3.5. Live database export needs SQL Server on the same machine.
- Demo and price. Free demo exports 25 records of every table. Full edition costs $149 with 30 days money back.
Test PCVITA SQL Backup Recovery on Your Damaged BAK File
Download the free demo, load your corrupt BAK file and preview every recovered object before you buy the full edition.
Safe & Secure · 30 Days Money Back*
