How to recover data in MSSQL database?

Question

SQL

The situation is as follows:
Missing MSSQL database, launched r-studio and saw that the database has been deleted (the volume of the database is about 180GB). We tried to recover the data - nothing happened. Restored from a full backup but as of 10/05/13, there is a diff backup for 02/15/14, but it can not be attached to the database that is now.
The most interesting thing is that *.ldf has been preserved, it has not been touched.
I read the article habrahabr.ru/company/officerecovery/blog/151056 and I really hope that someone will help me.
Perhaps there are specialists in mssql recovery who will restore the diff with data loss between the full and the beginning of the diff, and then finish it off with the surviving log.

Answer 1

Don't confuse people. Do you have MySQL or MSSQL? like the products are different. And most importantly - you are not busy with that. You need to figure out why it "disappeared" (someone erased / lost data on the storage / broken RAM) Until you decide to mess with the restoration too early.
And further. After deploying the backup, has the base already gone into battle? Or has nothing been released yet?

Answer 2

1. Backup the remaining log with NO_TRUNCATE, NORECOVERY options
2. Restore full backup with NORECOVERY option
3. Restore diff backup with NORECOVERY option
4. Restore log backup with RECOVERY option
Example:

BACKUP LOG TestDB TO DISK = 'C:\backup\TestDBLog.bak' WITH NO_TRUNCATE, NORECOVERY
RESTORE DATABASE TestDB FROM DISK = 'C:\backup\TestDB.bak' WITH NORECOVERY
RESTORE DATABASE TestDB FROM DISK = 'C:\backup\TestDB_diff.bak' WITH NORECOVERY
RESTORE LOG TestDB FROM DISK = 'C:\backup\TestDBLog.bak' WITH RECOVERY

PS. Don't forget the tambourine