Cleanup Task fails in SQl Server 64-bit

  • 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?

  • perhaps permissions issues at the OS level?

  • 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

  • I have same problem for shrinking of database.

    It does not give me any error but it does not shrink.

  • 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!

  • 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.

  • 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