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 |
|
danielc
Starting Member
49 Posts |
 Posted - 2007-12-11 : 16:13:40
|
| Hello all,I have looked at the frequently asked questions and have created and executed Tara's isp_deleteBackupHistory. At first I had several problems with the fk issue but resolved itself after executing several times. Now it executes in about a second if not less. I have gone through every DTS package and made sure logging is not enabled. For some reason or another our msdb file is still 15 GB... We have several DTS packages that create csv files for third party software. Any ideas where I can start investigating to bring the MSDB down in size?Thank you,D |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-12-11 : 16:22:11
|
| Try shrinking it, now that you have deleted some of the backup history.And make sure you delete old backup history records as part of your scheduled maintenance.e4 d5 xd5 Nf6 |
 |
|
|
danielc
Starting Member
49 Posts |
Posted - 2007-12-14 : 16:35:32
|
| thanks for the reply.I went ahead and executed dbcc shrinkfile on the msdb database and the file is very large (15 GB). Any suggestions? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
MSDB database far too large...