Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kernow
Starting Member
1 Post |
 Posted - 2009-02-04 : 04:25:40
|
| Hi everyone,I am hoping that someone can advise on this issue that I am having as I am a bit stumped.We are running SQL 2005 and the System model db is only 1.8mb but the System modellog.ldf is 47GB and the C drive is running out of space, only 500mb remaining.I have tried using Shrink but it made no difference, although I am not sure if I actually did this correctly.All the databases are backed up each night using Backupassist SQL Addon Module.I thought that backing up the model db would clear the .ldf file but I am obviously not correct in thinking this.I am trying to work out why the file is this large and what is writing to it.Can anyone advise me on what I can do?Thank you,Kernow |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-04 : 04:36:52
|
| see how much of log space is actually useddbcc sqlperf(logspace)try to backup log of model, not the database. I assume you won't need to restore your model at a point in time so you can backup log like thisbackup log model with no_logthan try to maximally shrink the log fileuse modeldbcc shrinkfile(modellog, 0)Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 09:09:27
|
| Are objects being created on Model Database?Any DML? |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-04 : 14:24:06
|
| something seriously wrong with your system db. |
|
|
|
|
|
|
modellog.ldf very large