How do I reduce log size?

[Stuartp]

The transaction log for one of our SQL Server databases is 4GB and I need to reduce it.

I've used the MS knowledge base and it says to run code "DBCC SHRINKFILE(pubs_log, 2), replacing this with my own log file name and size.

But it does not say HOW to run this, where to go to do it. Is this T-SQL?

I've spent ages searching on the web for how to run this but cannot find out. Does anyone know of an "idiot's guide" anywhere please I can go read, or can someone give me the steps I need to run this DDBC command?

Thanks

 

[gradley]

Yes it is SQL and you can run it in Query Analyzer. I would back up the log file first (if not in simple recovery mode) and then perform this command.

 

[pweegar]

Do you do regular SQL backups? IF so, you should be able to re-index and shrink your files during the backup.

 

[Stuartp]

We backup through Veritas backup exec, although this particular database is not used now, it was set up as an experiment a couple of years ago.

I have run the command in query analyser and it has worked a treat - I now have half of the server C drive free!!

Many thanks for you help.#

Stuart

 

[pweegar]

Maybe I should have said yoiu need to set up a Maintenance Plan for your db. This includes both optimizations and integrity checks. Set it up thru Enterprise Manager.