Share this article
Improve this guide
How to recover a deleted database in Windows
4 min. read
Updated onAugust 23, 2024
updated onAugust 23, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
In case you’re trying torecover 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:
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 aUSB flash drive.
There are two ways to restore a deleted database in this case:
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:
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:
How to restore a deleted database to a previous state
Follow the steps below to do this:
If you’re working with databases often, you might be interested in what to do if theDBeaver driver download has failed.
Did any of these solutions help? Let us know in the comments section below.
More about the topics:windows 10 fix
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
