thanks Wayne.. I will keep eye on the logs.

much appreciated.

alrite after running the jobs (backup, diff, transaction logs) I was in impression that taking the t-log backup will shrink the log file automatically. but doesn't look like it. do...

perfect.. normally I will be retaining backups for a month or may be for a year depending the company policy so we can restore to any time required.

the only reason...

thansk Gail Shaw. that was good explaination of transaction logs.

now coming bak to my scenario:

once I schedule full backup everyweek, diff backup everday and tlogs everyday twice...

sun full backup

mon diff

tue...

thanks pradeep.. that clears my confusion.. I did go through the books but got confused after reading so many articles about the backup.

Now I understand. thank you so much everyone:)

ok that make sense.

now consider this scenario

sunday full backed up 12:01 am

sunday tlog backedup up after the full backup is completed

monday tlog backed up at 10:00 am

monday differential backed...

so taking the backup of the log file will truncate the log file automatically? my plan was to once in a month, when the size grows shrink the log...

cool..thanks i will see how I go...

thanks for your help:) much appreciated.

thanks Steve,

is there a way to backup database (tables,,sps...etc) without any data.

also just to make sure there will be no downtime required as well for this changeover? this is live production server..

perfect.. thank you:)