October 13, 2008 at 8:35 am
We have installed sql server 2005(64-bit), also installed Sp2 and hotfix for build 3175..
But still when i create a new maintenance plan,
the backup task works fine, where the clean up task is not working and the back up files are not getting deleted.
Is its a bug in sql server 2005?Do we have any fix for this?
October 15, 2008 at 12:35 pm
perhaps permissions issues at the OS level?
October 15, 2008 at 3:06 pm
Hello,
Its a bug of SQL server.Most of cases it fails with deletion and optimization (or) integrity checks of database in maintanence plan.
Regards,
Sireesh
October 15, 2008 at 9:58 pm
I have same problem for shrinking of database.
It does not give me any error but it does not shrink.
October 16, 2008 at 2:19 am
mumu (10/15/2008)
I have same problem for shrinking of database.It does not give me any error but it does not shrink.
Try generating a script for your database shrink and running that from a query window. Check the 'Messages' tab and you should get your error message. Are you sure you want to shrink it? If it needs to grow again its likely to be more fragmented than it is now!
October 17, 2008 at 4:16 am
Thank you for your suggestion.
I will try out next time.
==================
I can manage to do it using Shrink File option.
1. Select Shrink File.
2. Select File Group and File Name
3. For Shrink Action, select reorganize pages before releasing unused space,
then set the file size which should be bigger then minimum required data size.
The required time is based on your data size.
It needs to do all the data files.
April 27, 2010 at 7:56 am
Hello
We've just moved to SQL 2005 64 bit and the cleanups are not working (as seems to be the case for a lot of people).
We're on SP3 so does anybody know if this is fixed yet?
The replies don't really indicate if this known bug has a fix yet and where it is available.
Many thanks in advance
Jackie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply