rithython (3/9/2011)
Thank you for your help. But, I got only the backup file in the old date before the TRUNCATE transaction. So, what should I do?
REstore it as a new database, copy the data over.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability