SQL Server Performance

backup failed

Discussion in 'Third Party Tools' started by reddynw, Jul 10, 2007.

  1. reddynw New Member

    we use third party tool for backups this failed to perform back up with error message below pls give some idea how to resolve the issue


    DESCRIPTION:3041
    BACKUP failed to complete the command SET DATEFORMAT ymd;BACKUP DATABASE [xyz] TO VIRTUAL_DEVICE='SQLsafe.0dce475d-7d98-4a66-94e8-656967556e4c', VIRTUAL_DEVICE='SQLsafe.0dce475d-7d98-4a66-94e8-656967556e4c.1', VIRTUAL_DEVICE='SQLsafe.0dce475d-7d98-4a66-94e8-656967556e4c.2' WITH BLOCKSIZ

    COMMENT:(None)
    JOB RUN:(None)

    thanks
  2. satya Moderator

    Why not perform backup using SQL statements and then use this tool to backup that file?
    What software you are using, veritas or sqlsafe?

    Just a couple of things to verify--make sure you don't have AntiVirus software running on that server and also make sure that drive doesn't have the COMPRESS setting enabled on the NTFS properties.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. reddynw New Member

    thanks for your reply.

    we are using sql safe as third party tool.

    we got this error message from back up schedule jobs which runs at midnight.

    It will be grate if u can provide more information on this.

  4. satya Moderator

    Have you read my reply completely, check the next line I have mentioned above.
    Also it is better to contact vendor in this case as it is a 3rd party tool issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. jgirl1010 New Member

    Reponse from Idera: We are happy to help you with SQLsafe. However, the error you are reporting is not a known issue. We need to get more information from you.

    Please contact us directly at support@idera.com.

    Thank you,
    Idera Technical Support
  6. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Best example to avoid third party tools and consequences for not using native SQL statements for such an important task of backups.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br />@<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a><br /><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page