When you have your recovery mode to full, you are supposed to make two types of backups:
Full backup every ones in a while - goes without saying I guess.
Transaction log backups every hour (or so) to keep the log file small and being able to do a point in time recovery I.C.E. If you skip this not only will the log file keep on growing, but the only restore you can do will be a restore from the full backup. And in that case you loose all the work from that moment on. If you backup the transaction log as well, you can do a roll forward and restore up until the last transaction log backup ... being max an hour ago ...
Hope this helps ...
Main Topics
Browse All Topics





by: aneeshattingalPosted on 2007-11-13 at 06:34:43ID: 20271688
seems like you are making the biggest mistake of "Not taking the log backup" , this is really very very critical as far as a DBA is concerned, 'remember' data is a valueable thing and the dba is responsable for taking care of that. So schedule a job to take the backup of your log file and schedule it at least twise in an hour.