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 2005 Forums
 Transact-SQL (2005)
 How to roll back

Author  Topic 

satya068
Posting Yak Master

233 Posts

Posted - 2011-01-07 : 12:11:40
Hi

can you please tell be how to rollbeack the data after truncating the table,
unfortunately my table got truncated now i need to roll back the data.

that perticular session was closed and opend again is it possible now?

Satya

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-07 : 12:20:01
You'll need to do a restore. You do have good backups, right?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

satya068
Posting Yak Master

233 Posts

Posted - 2011-01-07 : 12:25:56
Thanx for ur quick reply,

can you plz tell how to do restore backup plz?

Satya
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-07 : 12:34:02
Do you have backups?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

satya068
Posting Yak Master

233 Posts

Posted - 2011-01-07 : 13:11:37
ye,we do have back-ups.

thanx

Satya
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-07 : 13:20:22
You can use the restore wizard in SSMS or the RESTORE DATABASE command. For the GUI approach, right click on database and select the restore option.

What I'd recommend is that you restore to a new database, and then use INSERT INTO/SELECT to move your data from the newly restored database to your actual database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

satya068
Posting Yak Master

233 Posts

Posted - 2011-01-07 : 13:36:57
Thanx tara.

Satya
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-07 : 13:44:27
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -