Posted by: the_hareeb July 19, 2010
SQL server backup question
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.



Read Full Discussion Thread for this article