SQL Server Performance Forum – Threads Archive
Could not adjust the space allocationHi !
Yesterday optimisation job on SQL 7 failed reporting following error: could not adjust the space allocation for file dbname_DATA Job was running fine for a big while The drive which hold mdf and ldf file has 3.5 GB free space .mdf=1048 Mb
.ldf=32mb File grows by 10%
Could someone help?
Hi there, There is a known problem on SQL7.0 SP2… What service pack are you on? http://support.microsoft.com/defaul…port/kb/articles/Q254/2/53.ASP&NoWebContent=1 Another possibility is that another job is running against the database at the same time, eg. a backup job Cheers
7.00.1063 which is SP4
May take help of these KBAshttp://support.microsoft.com/default.aspx?scid=kb;en-us;317375 &http://support.microsoft.com/defaul…port/kb/articles/Q254/2/53.ASP&NoWebContent=1 and what is the recovery model on the database> _________
No those article doesn’t apply to my situation.
I will do as Twan suggested:reschedule Data Maintanence Plan jobs :
they are really all start in the same time.
Maybe this is the problem?
BTW how often Tlog backup is scheduled? _________
You can’t do a database or log backup at the same time as a shrink operation… and the error message seems to be a shrink operation failing… Cheers
How about the schedule? _________