InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:41:15 GMT20http://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspxFind the most recent backup prior to the truncate.Restore the database temporarily with a different name, such as "ProductionDB_20130115Backup" to identify what it is. Copy the table from ProductionDB_20130115Backup to ProductionDB. When you are confident you no longer need the restored database, delete ProductionDB_20130115Backup.Better than nothing I would think.Thu, 14 Feb 2013 07:08:36 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspx[quote][b]prettsons (2/13/2013)[/b][hr]If you don't have backup then you can also try [url=http://www.stellarinfo.com/sql-recovery.htm]third party SQL Database Recovery Software[/url] to repair your database. First try software demo version.[/quote]Except that the database wasn't damaged.Wed, 13 Feb 2013 23:17:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspxIf you don't have backup then you can also try [url=http://www.stellarinfo.com/sql-recovery.htm]third party SQL Database Recovery Software[/url] to repair your database. First try software demo version.Wed, 13 Feb 2013 20:57:38 GMTprettsonshttp://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspxThen the only way would be to restore the database from backup.Fri, 08 Feb 2013 03:33:36 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspx@GilaTruncate command was not in transaction.Fri, 08 Feb 2013 02:57:36 GMTchetanr.jainhttp://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspxUnless the truncate was run in a transaction that has not yet been committed or there's a recent backup to restore, that data is not coming back.Fri, 08 Feb 2013 02:53:19 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1417542-357-1.aspxHello Friends,I got a query from one of my team member’s friend. Here is the scenario :SQL server Version : SQL 2005Database Recovery Model : SimpleIssue : 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 ??Thanks, ChetanFri, 08 Feb 2013 02:45:36 GMTchetanr.jain