Well, got the test DB log file down to just over 500MB, from 59gig. Check it out. Now to tackle the Live DB. Thanks for all the help...

Great info, thanks for the links. No, I haven't run any reindexes while monitoring. Thanks for helping out a SQL rookie, you folks are great. I'll let you...

Well, been watching it for a few days, and it doesn't really get to 1% (see below, just before a log file backup). I'm thinking of shrinking to about...

Interesting. I didn't know you could take it down that far and only restore certain data to certain tables. We're running MS NAV 2009 ERP on SQL, and...

opc.three, you got me thinking about point-in-time recovery. If DB fails, would you not just restore the lastest full backup, do a tail end backup of the log file,...

This is great info folks. I want to thank you again for all the help. Log files are getting backed up nicely every hour on the hour, full...

Great info thanks. What would a sensible size be, 50 gig? I did notice a 'Shrink File' in the Maintenance Plan, is this what I use for the...

Autogrow settings 10% restricted to 2097152MB. DBCC LOGINFO returns 752 rows.

Went live with the Trans log backup this morning. As you can see the first file is huge. I guess that because it's never been done before. Hopefully...

Looks like we're cooking with gas now. I used the Maintenance Plan to schedule Log backups against the test DB every hour and looks like the backup files are...

Sound advice opc.three, just removed from the prod DB, and I'll configure on our test DB tomorrow, though not a lot of transactions going through, but at least I'll see...

Ok, just created a Maintenance Plan to backup the Trans Log file. It's going to run Mon-Fri from 7:00am to 7:00pm every three hours. I did say for...

Thanks for the info. It will be backed up to an external drive.

Thanks for the reply, that's great info. I'll be on it first thing tomorrow. I take it that I can do this while the DB is in use? We...