Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1386
  • Last Modified:

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

Hi all.

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

Thanks.
0
printmedia
Asked:
printmedia
  • 2
2 Solutions
 
Chris MangusDatabase AdministratorCommented:
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.

0
 
markterryCommented:
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
0
 
markterryCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now