Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 My Question : To restore database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-31 : 07:49:10
Mantosh Kumar writes "I had truncated a table from a database. Now i wanted to restore the truncated data. We had taken a backup 10 days ago and also we have transaction log file. But we want to restore tha database including truncated database."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-31 : 11:44:33
Then restore the database using the full backup. Then restore the log files but restore it up to the point in time of the truncate.

Tara
Go to Top of Page
   

- Advertisement -