Thanks Steve!

I was typing "select @@version" in Query Analyzer and displaying the results in "grid mode". And I didn't scroll far enough to see the info I wanted. "Text mode"...

Thanks for all the great ideas. I came up with this script to display the 'D'atabase sizes.

use msdb

select backup_start_date, logical_name, ROUND(file_size/(1024*1024),0) from

backupset join backupfile

on (backupset.backup_set_id = backupfile.backup_set_id) and file_type =...

Yes,

What happened in my case was that the DB backup failed to run (?) and all changes were stored in the log file. An 8GB log is not that big...

Thanks to everyone for your help.

I found another way to shrink the file size (on disk)of the ldf file: (only works if DB has 1 trans log)

sp_detachdb '<dbname>'

delete .ldf...

Andy,

I see your VB script but how do you run it from SQL? Do you schedule it at, say 10:30pm, assuming you stopped and started SQL server at 10pm?

Bill

P.S. I...

Andy,

You said that "It does change each time. I just reset it." Do you reset it in the morning and put up with a night of failed trans dumps...

Steve,

You say that one can write a stored proc to "do it and make it a startup proc". How do you make a "startup proc"?

"For #2, exactly - transactions are logged, but you can only do a full backup, not a log backup....