How to recover data from reinstallation of Windows server 2012 R2

Question

Hi there,

I'm facing a problem that I have restore the data from the backup and the data is not up to date.

Previously I had faced a windows update issue and cause the server to restart in a loop.

After restore the data from the backup. I notice that the data is not up to date.

I have 2 partitions
c:\ System/Application/Database engine.
e:\ SQL database mdf file.

Currently the mdf files is not up to date. It restore the data from the previous month.

The original mdf files is already up to last week data.

I not sure what happen to the backup.

I'm try to recover the data by using some tools to do a deep scan but it seem like cannot recover or I don't know how to use it.
Is there any way to recover this data?

T.Q.

Regards,

CL Lee

Answer 1

It is not clear what you did exactly. You talk about mdf files, and that is normally not how you restore databases.

However, a common error that people do is that they say:

RESTORE DATABASE db FROM DISK = 'C:\somepath\backup.bak'

and overlook that the backup file includes more than one backup. What happens in this case is that you will get the oldest backup in the file. To get a get a later file, you need to say, for instance,

RESTORE DATABASE db FROM DISK = 'C:\somepath\backup.bak' WITH FILE = 2

You can view which files there are in the backup file with the command

RESTORE HEADERONLY FROM DISK = 'C:\somepath\backup.bak'

Answer 2

After a database restore their is no going backup you would not be able to recover the data which was before you restored, unless you have backup which stored that.

Answer 3

Hi @CL Lee ,

I not sure what happen to the backup.I'm try to recover the data by using some tools to do a deep scan but it seem like cannot recover or I don't know how to use it.

Is there any way to recover this data?

What is your backup policy? Do you backup automatically or manually?
Or you do not backup recently but you expect the backup file can be restored to the latest the date as the it .mdf?
You can only restore it to the latest time of the backup file.

And after the backup or before the restore, you can use code as next to check the details of backup files.
restore headeronly from disk = 'X:\xxx\xxx.bak'

More information :
BR,
Mia
If the reply helped, please “Accept Answer” and upvote it.--Mia