Posted by: the_hareeb July 19, 2010
Login in to Rate this Post:
0
?
Hi, I am new to SQL server administration. Got a question about backups.
If I am on Full recovery mode. Here is the scenario.
1. Fullbackup @ 12am on Saturday
2. Disaster occures @1pm on monday
I HAVE NOT made any transaction log backups after I did my fullbackup @12am on saturday. I am still able to recover my database at the state it was @12:50pm Monday right? So why do i need to make periodical transaction log backups (DBAs suggest every 15 mins after full backup), if i can restore to any point in time after full backup without making any periodical transaction log backups.
Your help appriciated.