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 2008 Forums
 SQL Server Administration (2008)
 database recovery.

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2012-09-12 : 02:26:25
Hi,

is it possible to recover exact data(100% data) by using transaction log in case of disaster. if yes then can u plz let me know the step..


Thnx..

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-09-12 : 02:31:13
Yes, you can. But you must have a tail log backup for point in time recovery.

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page
   

- Advertisement -