SQL Server Performance

raid giving error

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by priyaram, May 30, 2007.

  1. priyaram New Member

    In our backup jobs , the backs and logdumps are put in to RAID(san) and our transaction log backups run once in 1 hour.
    in the middle , of running every hour once in a day it's failing by giving the error message
    "

    Database: TestAccount Timeout configuring virtual device set. (COM error code 80770003) [SQLSTATE 01000] (Message 0) [SQLSTATE 42000] (Error 50000). The step failed."

    And in the next run after an hour, it's success.
    I am not sure why it's failing by throwing the error message above
  2. satya Moderator

    Check the event viewer too for related hardware errors, have you verified with the hardware vendor?

    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.

Share This Page