Posted by: the_hareeb July 19, 2010
SQL server backup question
Login in to Rate this Post:     0       ?        
another scenario...

1.take full backup at 4:20pm
2.delete rowid=2 from dtabase @4:22pm
3.delete rowid=3 from dtabase @4:24 pm
4. I realize i should not have deleted rowid=3
5.make tail log backup @4:26pm and restore databse @4:23pm (I have both rowid=2 and rowid=3)

notice I have not made any t-log backups until step 5 where i made backup of tail log.

 
Read Full Discussion Thread for this article