Post reply

DB maintanance wizard

  • February 22, 2005 at 1:47 pm

    #109699

    i used the maintanance plan wizard to create a plan to do a full back up at the end of each business day and a transactional log back up every four hours for my databases.

    the problem is the job fails , when i read the text report, it backs up some of the databases but does not back up six of my databases and i get the message

    Backup can not be performed on database 'dbname'. This sub task is ignored.

    any ideas?

     

    [font="Comic Sans MS"][/font]It is what it is.

  • February 22, 2005 at 3:33 pm

    #543574

    Is the error during the full backup or transaction log backup?

    If it's the transaction log backup, check the recovery model of the databases that fail. You can't do transaction log backups for database using the simple recovery model. If thats the problem, either change the recovery model, or exclude those databases.

     

    --------------------
    Colt 45 - the original point and click interface

  • February 23, 2005 at 5:03 am

    #543656

    thanks will do

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply