August 19, 2004 at 8:39 am
I have a server running SQL7 SP3, it has a Db on it that is 166gb in size, the db is made up of several smaller files, the biggest of these is 126Gb in size. I can shrink all the files in question, bar this one. When ever we try to shrink it it stops after about 10mins reporting the server has run out of locks. We have even put the db into single user mode and this still happens. It has 512Mb Ram and has RAM allocated right upto the limit to SQL. Is increasing the amount of locks a safe option or is there something else that can be tried, we can't dts the data to another server and do it that way either
August 19, 2004 at 8:49 am
Increasing locks will increase the amount of memory SQL Server uses. You can try that.
You may decrase file size little by little each time to see what is going to happen.
August 20, 2004 at 3:19 pm
how about placing your db into simple recovery mode
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply