modellog.ldf 8 GB how to shrink - SQL Server 2000

printmedia
printmedia used Ask the Experts™
on
Hi all.

How do I shrink the size of the modellog.ldf, it's currently at 8GB.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chris MangusDatabase Administrator
Commented:
Nothing should be using model database.  Strange.  I would investigate that.

Anyway, you can shrink it like any other database, right-click on the database, choose tasks, shrink files, select the log file, choose reorganize pages and set the value to 1.  Then, click ok.

It depends on your recovery model. If your recovery model is full (default) then you need to change it to simple recovery model to do a file shrink on the log (right click database, shrink > files, select log).

For more information on recovery models see this article (requires signup) or do a google search for "SQL Server Recovery Models".
SQL Server Central - Recover Models Article
Sorry, just noticed it was a system db you were talking about. Same theory applies, try to shrink before changing recovery model.

See this article possibly:
http://www.itbangbang.net/2010/06/how-to-shrink-large-modellogldf-file.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial