I got a query from one of my team member’s friend. Here is the scenario :
SQL server Version : SQL 2005
Database Recovery Model : Simple
Issue : Jr. DBA has run a truncate command on a table having 1 mn rows (confused on similar naming convention between production / dev) . After knowing the mistake, he requested for data recovery.
Unfortunately, the database is quite old, 2 Weeks back.
Any Ideas ??