Restore data

A colleague asked the HR girl why he couldn't view his own salary and attendance data on our OA system, and the the HR girl passed the question to me.

Then I ran the SSMS to analyze the case, and found that the oldest data tables had been deleted. I asked my supervisor the problem, he said our data of OA in database was huge, to reduce the scale, he deleted the oldest data, the data more than 10 years. But according to the requirement from the finance department, the data can't be deleted. My supervisor told me to restore the data from the backup database. So today's task was to write temporary SQL code in SSMS to restore data from backup database.

In terms of coding, no matter how familiar I was in a project, there were still chances to write some bug and cause other problem, before applying code to real data, the code must be tested first to make sure it is valid. This is my experience and lesson from many years of work.

Of course, the task was done successfully before getting off today.