Simon

I've read loads of stuff about appropriate autogrowth increments. I get the fact that you should not use percentages but have never come to a proper conclusion about appropriate...

Guys

I hate to keep banging on about this but my databases use simple recovery. Log backups are, pardon the pun, simply not an issue.

Regards

George25

Guys

I've yet to see a convincing argument for not shrinking log files for databases using the simple recovery model where the transaction log is not crucial - the databases are...

Paul

So, bearing in mind that my log files have all been shrunk, would you advise me to recreate them or just stop shrinking them?

Regards

George25

I have quite a few very large databases and, like Giles above, I need to shrink the log files after large amounts of data are imported into the databases. ...

Just read my last post. Not sure what happened to the text but what I wrote got garbled in the translation. What I meant was F:\data\dbname.mdf

Sean

It would be really useful if you could add the path and fiilename of the database and log files to the Database Size (Summary) / Distribution Stats table, e.g. F:\dataorthwind.mdf.

George25

Sean

Sorry it took a while to get back to you. I was running the report on SQL 2000 - I didn't realise that it it was only written for...

Sean

I've tried your script but get a whole load of errors (see below). I'd be grateful for your help as your report looks really useful.

Msg 170, Level 15, State...