September 2, 2011 at 11:05 am
juan08 (9/2/2011)
Thank you for helping ALZDBA.The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t know why or how to fix it and then he didn´t pay much attention of what we have found here with you guys. (seems common around here with sql experts...they think they know more than everybody else)
Any way...we are today giving service one at a time. SAP is up for two hours now and seems to be fine without issues on the server. In a while we will give some other services...
I will try to use the script johan give us and then I will post the result.
Juan
As LutzM advised, it is best to run the script in sections (go to go) .
Start with reading it over so you know which part is handling what kind of data.
You will notice you have to adapt the "use " clauses at different sections, because it needs to be run in the db where SSB is active.
MSDB has this special role at instance level, so that one is a special case !
I left the cleanup part in comment and that is on purpose !
You should only do that if really needed !
In that case, make sure you log files are large enough ( or can extend to handle the load you choose )
Also keep in mind msdb will not shrink by itself !
If you decide it should shrink, shrink at file level and do full index rebuild afterward, for the db to be in the most optimal state.
Please backup before and after !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing post 31 (of 30 total)
You must be logged in to reply to this topic. Login to reply