English
日本の
PCVITA software to repair corrupt SQL Server MDF and NDF files
SQL Database Recovery Tool
PCVITA SQL Database Recovery Tool repairs corrupt, damaged and suspect SQL Server database files and brings back tables, views, stored procedures, functions, triggers, rules, indexes and keys from the primary MDF file and its NDF files. SQL recovery software restores deleted records and dropped objects with Advance Scan, previews every item and exports the result to a live SQL Server database, a .sql script or CSV files. Free demo previews everything and exports 25 records per table.
- Input
- Corrupt MDF file with one or more NDF files, SQL Server 2000 to 2025, any size
- Output
- Live SQL Server database, .sql script files or CSV files
- Recovers
- Tables, views, stored procedures, functions, triggers, rules, indexes and keys
- Scan modes
- Quick Scan for normal corruption, Advance Scan for severe damage and deleted records
Also brings back records deleted from a table, marks them in red and sends the result into a SQL Server on another machine in your network. See all features. For a damaged .bak backup file, open the SQL Backup Recovery Software.
How SQL Database Recovery Tool Repairs a Corrupt MDF File
Damaged primary and secondary files enter at the left. Recovered tables, objects and records leave at the right, as a live database, a script or CSV files, with keys and schemas kept.
Corrupt MDF and NDF Files
SQL Server 2000 to 2025, no file size limit
- Suspect, inaccessible or attach failed databases
- Primary MDF file with its secondary NDF files
- Files hit by ransomware or a SQL injection attack
PCVITA SQL Recovery Software
Works on your Windows machine, no SQL Server needed to scan
- Quick Scan or Advance Scan
- Deleted records shown in red
- Scan result saved to .str for later
Healthy SQL Server Database
Three output options, from a live server to CSV files
- Tables, views, procedures, functions and triggers
- Primary keys, foreign keys and indexes retained
- Schema only or schema with the data
- 1OpenSelect the damaged MDF file and let the tool find its NDF files.
- 2ScanChoose Quick or Advance Scan and preview the recovered objects.
- 3ExportSend the objects to a live SQL Server, a .sql script or CSV.
Recover Your Corrupt SQL Database in 6 Steps
Six screens of the SQL recovery software from the first click to the recovered database. Click a step to load its screen, or read the full walkthrough in the Software Guide.
Step 1. Open the Corrupt MDF File
Install SQL Database Recovery Tool on Windows and start it. Click Open, browse to the corrupt MDF file and select it. SQL Server does not need to be installed on the machine.
Step 2. Choose Quick or Advance Scan
Select Quick Scan for a database that opens with errors. Select Advance Scan for a heavily corrupted file and tick the deleted records and deleted objects options to bring back dropped tables, procedures and triggers.
Step 3. Set the Version and Add NDF Files
Leave Auto detect ticked or select the SQL Server version of the file yourself. On the NDF Options tab, let the tool detect the secondary files or click Add Files or Add Folder to add them, then click OK.
Step 4. Save the Scan and Preview Objects
When the scan completes, click Yes to save the scan result as a .str file so a large database does not need a second scan. Expand the tree and click any table, view, stored procedure, function or trigger to preview it. Deleted records appear in red.
Step 5. Select the Export Option
Click Export. Choose SQL Server Database to write into a live server, SQL Server Compatible Scripts for a .sql file or CSV File Format for table records. For a live server, enter the server name, sign in with Windows or SQL Server authentication and create a new database or select an existing one.
Step 6. Tick the Objects and Finish
Tick the tables and objects you need. Select With Only Schema or With Schema & Data, tick Export Deleted Records and Export Deleted Objects if you want them and click Export. Click OK on the Export Completed window and open the database in SQL Server.
Free demo, no licence needed to preview every object and export 25 records from every table.
SQL Recovery Software Features
What PCVITA SQL Database Recovery Tool does with a damaged SQL Server database, grouped by task.
Repairs Corrupt MDF and NDF Files of Any Size
Damaged primary and secondary database files load in one step, whatever their size.
Repair the Primary MDF File
SQL Database Recovery Tool scans a corrupt or inaccessible MDF file and rebuilds tables, views, procedures, functions and triggers along with rules, indexes and keys.
Add One or Many NDF Files
Secondary NDF files that belong to the MDF load by auto detection or by hand with Add Files or Add Folder, so data spread over several files comes back together.
No Database File Size Limit
Large MDF files repair without a size cap. Save the scan to a .str file and reload it later instead of scanning the database again.
Auto Detect the SQL Server Version
SQL recovery software detects the version of the file on its own, from the 2000 release up to SQL Server 2025. You can also set it by hand before the scan.
Suspect and Attack Hit Databases
Files from a database stuck in SUSPECT state and files damaged by ransomware or a SQL injection attack open in the same way.
Recovers Deleted Records and Dropped Objects
Rows that a DELETE statement removed and objects that a DROP statement removed come back with Advance Scan.
Recover Deleted Table Records
Advance Scan brings back records that were deleted from a table and marks them in red in the preview, so you tell old rows from recovered ones at a glance.
Restore Dropped Tables and Procedures
Tick Recover Deleted Objects and the scan lists deleted tables, functions, views, stored procedures and indexes for export.
Primary and Foreign Keys Come Along
Primary keys, foreign keys and indexes recover with their tables, so relationships hold in the exported database.
Standard and User Defined Schemas
Tables under the dbo schema and tables under a schema you created both recover, dropped schemas included.
JSON, XML and Vector Data Types
JSON, Vector, XML, datetime2, datetimeoffset, sql_variant, hierarchyid, geography and geometry columns recover, with ASCII and Unicode text.
Previews Every Object Before You Export
Check the recovered database on screen object by object and decide what goes out.
Tree View of Every Object
Every recovered object sits in a tree. Click a table to see its records. Click a view, procedure, function or trigger to see its definition.
Deleted Items in Red
Recovered deleted records and dropped objects show in red, so you can check them before they reach the destination.
Binary and Document Data
Records that hold documents in binary columns preview as binary and export as they are.
Save and Load the Scan
Save the scan once as a .str file. In the next session, use Load to open it and skip a second scan of a large database.
Exports to a Live Server, SQL Scripts or CSV
Recovered data goes straight into SQL Server, into a .sql script you apply anywhere or into CSV files.
Export to a Live SQL Server Database
Enter the server name, sign in with Windows or SQL Server authentication and create a new database or write into an existing one, on this machine or on another server in the network.
Export as Compatible SQL Scripts
Without SQL Server on the machine, save the schema or the schema and data as a .sql script and apply it on any server later.
Export Table Records to CSV
Save table records as CSV files for an archive, a spreadsheet or an import into another database.
Schema Only or Schema and Data
Choose With Only Schema to rebuild the structure or With Schema and Data to move the records too, with the collation you set.
Export Into a Newer SQL Server
Recover a database from an older SQL Server version and write it into a newer one, up to SQL Server 2025.
See these options on your own database. Free demo previews every object and exports the first 25 records of a table.
Why DBCC CHECKDB is Not Enough for a Damaged SQL Database
Four limits of the native repair that Microsoft documents and what PCVITA SQL recovery software does instead.
- 1
Repair at the Cost of Your Data
Microsoft marks REPAIR_ALLOW_DATA_LOSS as an emergency last resort. Data the repair deallocates is no longer accessible or recoverable. PCVITA tool opens the damaged file, previews what it recovers, deleted records included, then exports the result to a new destination.
- 2
Single User Mode and a Backup First
Repair options need the database in single user mode. Microsoft also asks for physical copies of the MDF, NDF and LDF files before any repair. SQL recovery software opens that copy on any Windows machine, with no SQL Server installation needed to scan and preview.
- 3
Suspect Means No Access at All
SQL Server marks a database SUSPECT when the primary filegroup is damaged and recovery fails at startup, and the database stays unavailable until you act. PCVITA tool opens the data files behind a suspect database and exports the recovered objects into a fresh one.
- 4
Restore Beats Repair, but Only With a Backup
Microsoft recommends a restore from the last known good backup as the primary route. With no backup, DBCC repair is what remains, and it reports errors instead of showing you the data. PCVITA SQL recovery software shows every table, object and record before you export.
Prepare Before Using SQL Database Recovery Tool
Seven checks before the first scan. Work through them, then start the tool.
- Copy the MDF, NDF and LDF files before anything else. Microsoft asks for physical copies before a repair, and the copy is what you load into the tool.
- Install Microsoft .NET Framework 4.5 or later on a Windows machine with 100 MB free disk space and 4 GB RAM.
- Open the tool with Run as Administrator on Windows 11, 10, 8 and 7 and on Windows Server 2016, 2012 R2 and 2008.
- Note which SQL Server release wrote the file if you know it. Auto detect finds it, and a manual selection covers a file that auto detect cannot place.
- Collect every NDF file that belongs to the MDF. PCVITA tool accepts an NDF file only when it belongs to the selected primary file.
- Keep SQL Server login details ready for a live export, either Windows authentication or a SQL Server login with rights to create a database.
- Try the free demo on your own MDF file before you buy. Download the SQL Database Recovery Tool demo, preview every object and export 25 records from every table.
System lines match the Specifications table below, and the backup line follows the Microsoft Learn page linked in the Sources.
SQL Recovery Software Pricing
Free demo first, then one licence. Both editions share every scan and export option, only the record count differs.
Demo Edition
Free
Preview every object, export 25 records per table and 5 other objects
- Export limit25 records a table
- FeaturesAll
- LicenceNot needed
Version 14.0, 8.89 MB, Windows
Full Edition
$249 one licence
Export every record and every object from the database you load
- Export limitNone
- FeaturesAll
- DeliveryEmail within minutes
30 Days Money Back*, Safe & Secure checkout
Included in both editions Demo and full edition share every option, only the record count differs
- Add an MDF File With One or Many NDF Files
- Quick Scan and Advance Scan Modes
- Recover Deleted Records and Objects
- SQL Server Version Auto Detection
- Preview of Every Database Object
- Save the Scan as .str and Load It Later
- Schema Only or Schema and Data Export
- Live SQL Server, SQL Script and CSV Output
SQL Database Recovery Tool Specifications
Version, system needs and recovery limits in one place.
| Version | 14.0 |
|---|---|
| File size | 8.89 MB |
| Windows versions | Windows 11 (64 bit), Windows 10, 8 and 7 (32 and 64 bit), Windows Server 2022, 2019, 2016, 2012 R2 and 2008 |
| Prerequisite | Microsoft .NET Framework 4.5 or later, started with Run as Administrator |
| Hardware | Intel Core 2 Duo E4600 2.40 GHz processor, 4 GB RAM, 100 MB free hard disk space |
| Free demo limit | Preview of every object, export of 25 records from every table and 5 other database objects |
| Delivery | Download link and activation key arrive by email within a few minutes of payment confirmation |
| Input files | Primary MDF file with one or more secondary NDF files |
|---|---|
| SQL Server versions | 2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000 |
| Objects recovered | Tables, views, stored procedures, functions, triggers, rules, indexes, primary and foreign keys, standard and user defined schemas |
| Data types | JSON, Vector, XML, datetime2, datetimeoffset, sql_variant, hierarchyid, geography, geometry, ASCII and Unicode |
| Scan modes | Quick Scan for normal corruption, Advance Scan for severe corruption, deleted rows and dropped objects |
| Output | SQL Server database on a live server (new or existing), compatible .sql scripts and CSV files |
| SQL Server installation | Not needed to scan, preview or save scripts and CSV files. Needed on the destination server for a live export |
| Files per session | One MDF file at a time, with as many NDF files as belong to it |
SQL Database Recovery Tool vs DBCC CHECKDB Repair
Microsoft’s own consistency check and repair next to PCVITA tool, so you can decide which route fits your database.
| Point | DBCC CHECKDB Repair | PCVITA Tool |
|---|---|---|
| What it does | Checks logical and physical integrity and repairs the errors it reports | Scans the primary and secondary files and rebuilds objects and records |
| Data loss | REPAIR_ALLOW_DATA_LOSS can cause data loss, a last resort in Microsoft’s words | Recovers records, deleted ones too, then shows them before export |
| Database state | Database attached and in single user mode for a repair | Copy of the files, no attach and no SQL Server needed to scan |
| Suspect database | Unavailable until an admin changes its state | Opens the data files behind it directly |
| Backup | Physical copies of MDF, NDF and LDF files before a repair | Same advice. Load the copy and keep the original |
| Preview | Error messages in the output, no view of the records | Tree preview of every object, deleted items in red |
| Output | Repaired database in place | New or existing SQL Server database, .sql script or CSV files |
| Price | Included with SQL Server | Free demo, full edition $249 |
DBCC CHECKDB facts come from DBCC CHECKDB (Transact-SQL) on Microsoft Learn. Database state facts come from Database states on Microsoft Learn. PCVITA tool facts match the Specifications and Features sections above.
Database State Check Before You Blame Corruption
- RECOVERY PENDING points to a resource error during recovery. Microsoft says the database is not damaged, so check for missing files or low system resources first.
- RECOVERING is a passing state. If recovery succeeds, the database comes online on its own. If it fails, the database becomes suspect.
- SUSPECT means at least the primary filegroup is damaged and the database could not recover at startup. The database is unavailable.
- EMERGENCY is a state a sysadmin sets by hand. The database goes read only in single user mode, which gives a look inside a suspect database.
- Suspect with no clean backup is the case for PCVITA tool. Copy the MDF file with its NDF files and load the copy.
Open the Software Guide for the export options that write the recovered objects into a new or an existing SQL Server database.
Sources for SQL Database Recovery Facts Microsoft pages behind the native repair facts on this page
- Microsoft LearnDBCC CHECKDB (Transact-SQL)
- Microsoft LearnDatabase states
- Microsoft LearnDatabase files and filegroups
SQL Database Recovery Tool FAQs
Answers to the questions users ask before and during a SQL database recovery, grouped by topic.
Working and Limits How the tool behaves during the recovery
How does the SQL Database Recovery Tool work?
Six steps recover a corrupt SQL Server database.
- Step 1. Open PCVITA SQL Database Recovery Tool and click Open to select the MDF file.
- Step 2. Choose Quick Scan or Advance Scan.
- Step 3. Keep Auto detect on for the version and add the NDF files.
- Step 4. Save the scan as a .str file and preview the objects.
- Step 5. Click Export and choose SQL Server Database, SQL Server Compatible Scripts or CSV.
- Step 6. Tick the objects, choose only the schema or the schema with data and finish the export.
Can the tool repair an MDF file that DBCC CHECKDB could not fix?
Yes. PCVITA tool opens the MDF file and its NDF files directly, so errors that DBCC CHECKDB reports or fails to repair do not stop the scan. Copy the files, load the copy and select Advance Scan.
Does SQL recovery software recover deleted records from a table?
Yes. Advance Scan recovers records that were deleted from a table and marks them in red in the preview. Tick Export Deleted Records on the export screen and they go out with the rest of the data.
Is there a database file size limit?
No. PCVITA tool repairs an MDF file of any size with its NDF files. For a large database, save the scan result in a .str file and load it later instead of scanning again.
Can I recover a database that is in SUSPECT mode?
Yes. Copy the data files of the suspect database, load the copy into PCVITA tool and export the recovered objects into a new database. Microsoft notes that a suspect database stays unavailable until you act, and the file copy is the way around that.
Can I recover several databases at once?
No. PCVITA tool loads one MDF file per session. One MDF file with several NDF files is fine, since the NDF Options tab adds every secondary file that belongs to it.
What about SQL Server errors 823, 824 and 5123?
Load the MDF file and scan it. SQL Server errors 823, 824 and 5123 make the database inaccessible, and the PCVITA tool scans the file behind the error, recovers the objects and exports them to a fresh database.
How do I load a saved .str scan file?
Use the Load option in the menu bar. Browse to the .str file saved after an earlier scan, and the recovered objects appear without a second scan of the database.
Demo and Price What the demo covers and what a licence costs
What does the free demo of the SQL recovery tool do?
Everything but a full export. Demo edition scans the primary and secondary files with either scan mode, previews every object and exports 25 records per table and 5 other database objects to any of the three outputs.
What does the full edition of the SQL recovery tool cost?
$249. Full edition removes the 25 record and 5 object limit and comes with a 30 day money back guarantee. Download link and activation key reach your inbox within minutes of payment.
Compatibility and Exports SQL Server and Windows versions, SQL Server installation, scripts and collation
Which SQL Server versions does the SQL recovery tool support?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000. Auto detect finds the file version, or you select it by hand before the scan.
Which Windows versions does PCVITA tool work on?
Windows 11 (64 bit), Windows 10, 8 and 7 (32 and 64 bit) and Windows Server 2022, 2019, 2016, 2012 R2 and 2008. PCVITA tool needs Microsoft .NET Framework 4.5 or later, 4 GB RAM and 100 MB free disk space, and starts with Run as Administrator.
Do I need SQL Server installed to repair an MDF file?
No. Scan, preview, SQL script export and CSV export work without SQL Server on the machine. Only the live export needs a reachable SQL Server instance, on the same machine or in the network.
Can the tool export the recovered data as a SQL script?
Yes. Choose SQL Server Compatible Scripts as the export option, select With Only Schema or With Schema and Data and save the .sql file. Apply it on any SQL Server later.
Does the export keep the collation and user defined schemas?
Yes. Before a live export you see the default collation and can change it from the drop down. Tables under the dbo schema and under schemas you created export with their schema, dropped schemas included.
Question not answered here? Ask on Live Chat or send it from the Contact Us page.
SQL Database Recovery Tool Reviews
Ratings collected on pcvita.com and what customers wrote after their SQL database recovery.
Few months ago, our organization faced a big trouble as our SQL Server Database encountered severe level corruption. Unfortunately, there was no backup of our database file, which made the situation even more problematic. After surfing a lot, recommendation of SQL Database Recovery Software appeared as a blessing to us. It successfully recovered data from the corrupted database. Thanks to the developers of Pcvita for this useful utility.
Our database became inaccessible and it showed error Msg 945, Level 14, State 2, Line 1. After googling, we found that our database went to suspect mode. Someone recommended to try SQL Database Recovery Software and the tool successfully repaired suspect database to normal mode.
As a Database administrator, my responsibility is to take care of the database on a regular basis. As we have to deal with SQL Database corruption. This SQL Database recovery tool proves to be helpful in recovering corrupted database and recovers deleted data from SQL Server.
GearDownload: 100% clean badge, no spyware, adware or viruses found in PCVITA software.
DownloadAtoZ: 5 star award for PCVITA software. Every badge is on the PCVITA awards page.
Key Takeaways on SQL Database Recovery
The short version of this page.
- Files and versions. PCVITA tool repairs MDF files and their NDF files from SQL Server 2000 to 2025 with no size limit.
- Two scan modes. Quick Scan covers normal corruption, Advance Scan covers severe damage, deleted rows and removed objects.
- Preview and export. Every object shows in a tree before it goes into SQL Server, a .sql script or CSV files.
- Native repair limits. DBCC CHECKDB repair can lose data and needs single user mode, so Microsoft calls it a last resort.
- Demo and price. Free demo exports 25 records a table plus 5 other objects, and the full edition costs $249 with 30 days money back.
Test the SQL Database Recovery Tool on Your Damaged MDF File
Download the free demo, scan the MDF file, preview every object and export the first 25 records of a table before you buy the full edition.
Safe & Secure · 30 Days Money Back*