Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    35

    Unanswered: Vague SQL backup error message...

    I am getting the following error on one of my databases...

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

    This is the hourly transaction log backup. All of the other datbases backup fine, just this one fails. Any ideas?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Your database is set to simple recovery, which means that transaction logs are not kept. So trying to backup the log is pointless.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2007
    Posts
    35
    CRAP!
    This is the secnd time i've done this.....lol

    DUH!!!!

    Thanks.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hey, if I hadn't done the same thing a dozen times I wouldn't have known the answer off the top of my head!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •