Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: Backup Tape Failure on SQL2000

    Hi,

    I'm sure to get help from you with my problem. Thanks.

    I'm using MSQL2000 Server Standar Edition (w/SP4) on a WS2003 Standar Edition (Spanish) and the type drive is a Quantum SDLT-600

    I get failed backups with the following error in event viewer:

    Id Suceso: 17055
    18210:BackupTapeFile::UnloadTape: Prepare Tape failure on backup device '\\.\Tap01'. Operating system error 1 (Función incorrecta)

    This messege appears a few hours from the backup is started and I can't get any backup with this tape drive.

    Sometimes the Tape is dismounted from the list of devices connected to the server.

    Any idea will be greatly appreciated

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Identify hardware failures from reviewing the system event log, and address the findings with the vendor. There have to be posted errors in there, because the function call is the same, and SQL engine just passes the call to the OS, who passes it to the vendor kernel-level API. Most likely there is a problem in that layer.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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