Post reply

Backup to Tape from SQL 2000

  • February 28, 2009 at 5:30 am

    #200309

    Hi All,

    I tried running the below command in the query analyser to take a backup straight to tape drive.

    BACKUP DATABASE MASTER TO TAPE='\\.\TAPE0' WITH NAME='MASTER COMPLETE', NOUNLOAD

    The event viewer log shows the backup is successfull.

    ++++++++++++++++++++++++++

    Database backed up: Database: ReportServer, creation date(time): 2008/10/06(14:22:33), pages dumped: 4400, first LSN: 167:3533:1, last LSN: 167:3535:1, number of dump devices: 1, device information: (FILE=1, TYPE=TAPE: {'\\.\TAPE0'}).

    ++++++++++++++++++++++++++

    but when i try to retrieve the data from the tape, I can see only NO ENTRIES FOUND. The restore report shows 0 files and directory

    -----------------------------------------

    Restore started on 2/26/2009 at 7:38 PM.

    Restore completed on 2/26/2009 at 7:38 PM.

    Directories: 0

    Files: 0

    Bytes: 0

    Time: 5 seconds

    -------------------------------------------

    Could somebody enlight me where exactly things going wrong

    Thanks,

    Gopi

  • February 28, 2009 at 6:01 am

    #951506

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic666149-24-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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