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 |
|
carloarango
Starting Member
15 Posts |
 Posted - 2010-10-01 : 15:30:26
|
| the MSDB log is about 15 GB whereas the data file is only 6 GB. Is there a way to shrink the MSDB log?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-01 : 16:48:44
|
| Somewhat scary that the Data on MSDB is 6GB - you perhaps not clearing down stale backup history data?You might have a shed-load of jobs I suppose ... but even so, 6 GB is a lot.MSDB uses Simple Recovery Model AFAIK ... so for your LDF file to get that big something has racked up some huge transactions. Maybe a delete of the old history data? In which case you could usefully shrink the Data file too. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-01 : 21:36:35
|
| by default msdb is in simple, but some will switch it to full |
|
|
|
|
|
|
Shrinking the MSDB logs