How to recover a deleted database in Windows

By: Elsie Otachi
4 minute read
recover deleted database

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

In case you’re trying to recover a deleted database, either because it happened by mistake, or you think it could have been moved, there are solutions to fix it.

Most of the time, your computer has a backup copy of the deleted database, so recovery involves:

  1. Restoring the database from the backup database, or
  2. Restoring the deleted database to a previous state.

We’ll show you how to do both so as to recover a deleted database.

How to restore deleted databases

Solution 1: Restore a deleted database from the backup database

In order to restore a deleted database, your computer has to have a backup copy of the file or folder, which is also known as ‘known good copy’ of the database file or folder.

This copy is one which you are sure of its integrity and design.

To set off the restoration process, use the Backup Database command within Microsoft Office Access so as to make backups. However, you can also use any known good copy to restore the deleted database such as that stored in a USB flash drive.

There are two ways to restore a deleted database in this case:

  • Restore the entire deleted database
  • Selectively restore, or restore part of the deleted database

Without a backup copy, data loss, corrupted database design and unwanted changes are expected so you need to make backups regularly.

How to restore an entire database

Restoring an entire database simply means you’re taking the backup of the database, and replacing the previously deleted database that may have been damaged, or has other issues altogether.

Missing database files almost always have backup copies so replacing the database means you locate the backup copy, and then put it where the deleted database should be – the correct location – because some databases or programs are linked to objects in the particular database, and if not restored correctly, these will not work, or you may have to recreate them all over again.

Before restoring an entire database, delete the damaged file, and replace it with the backup copy.

How to selectively restore a database

If you intend to restore a part of the deleted database, import the object from the backup copy into the database with the object you want to restore.

Follow these steps to restore files from a backup:

  • Firstly, ensure the media or drive your backup copy is saved on is available
  • Right click Start
  • Select Control Panel
  • Click System and Security

deleted database

  • Click Backup and Restore

deleted database


For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

  • Click Restore my files
  • Follow the instructions in the wizard

Solution 2: Restore a deleted database to previous state/version

A previous version of a database has copies of files and folders saved automatically by Windows as part of a restoration point, or restore point.

Such copies are also known as shadow copies.

In order to restore files and folders to previous versions or previous state, do the following:

  • Click Start
  • Select File Explorer

deleted database

  • Go to the folder that contained the deleted database
  • Right click on the file or folder
  • Click Restore previous versions
  • If the folder was at the top level of a drive, right click the drive, then click Restore previous versions. A list of available previous versions (including files saved on a backup), and restore points
  • If you want to restore a previous version of a file or folder in a library, right click on the location of the file/folder, not in the library, then click Restore previous versions

How to restore a deleted database to a previous state

Follow the steps below to do this:

  • Click Start
  • Select File Explorer
  • Go to the folder that contained the deleted database
  • Right click on the file or folder
  • Click Restore previous versions. If the folder was at the top level of a drive, right click the drive, then click Restore previous versions. A list of available previous versions (including files saved on a backup), and restore points
  • On Previous Versions tab, you’ll see some previous versions of files. Before you restore a previous version, select the previous version, then click Open to view it (ensure it is the version you want)
  • Select the previous version, then click Restore. This replaces the current version on your computer, and this cannot be undone.

Did any of these solutions help? Let us know in the comments section below.

RELATED STORIES TO CHECK OUT:

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

Next up

Best Windows 10 antivirus software to use in 2018

By: Radu Tyrsina
7 minute read

Update – 2018 will soon come to an end and we already have a guide on what is the best antivirus you should get in […]

Continue Reading

These features are out for good with Windows 10 version 1809

iamsovy@gmail.com' By: Sovan Mandal
2 minute read

Microsoft is all set to launch its next big update, Windows 10 version 1809 in October. While that should be a nice piece of news […]

Continue Reading

Windows 10 18H2 builds no longer receive new features

By: Matthew Adams
3 minute read

The Windows 10 October 2018 Update (otherwise 18H2) rollout might now be two to three weeks away. For the last few months, new build previews […]

Continue Reading

Discussions