| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-03-01 : 18:29:47
|
| The MODEL Database occupies more than 95 percent of its allocated Log Space Used.Is it ok to keep it like this or needs something to do (Since it is System database can't do much).Can anyone have any ideology for this.Thanks in Advance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-01 : 18:34:15
|
| You can do almost anything to model except DROP it and change certain minor settings.95% isn't that important, what's the size of the log file? If it's larger than 8 or 16 MB then you should check for unwanted data or objects that might have been accidentally created in model. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-03-01 : 18:54:38
|
| Thanks for that reply.I have 164 MB on Model Log Space currently, (perhaps it is less as what you might say) but my MDF for Model is 1 MB.Based on this assumption, how to reduce this unwanted space.Also, I dont have any unwanted objects residing on this database apart.Please advise, Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-03-01 : 19:09:23
|
| Thanks All.However, MODEL is FULL Recovery Model.What would be the difference if I am not procured Backup Log OR Truncate the Log for MODEL?What would be the best time to do (During business hours OR After hours).Thanks once again. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-01 : 20:14:53
|
| You can do anything you want to model at any time. It's not used by the system for anything except as a...wait for it...model for new databases, particularly for tempdb when SQL Server is (re)started. It's useful for setting defaults: file size and growth increment, recovery model, ANSI settings, and so on. These can always be overridden on a new database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
MODEL Database LDF