I have been trying to restore a backup file (BAK) in SQL 2000 ENT SP4 on a WS
2003 ent server. When I try to restore it reports that is not the correct
tape backup type. This file was backuped to my hard drive, not a tape drive.
I think the filr may be corrupted/damaged... Is there a way to repair a .bak
file or what is going on?

BDG

Brenton D. Glisson, MD (Brenton D. Glisson, M*@discussions.microsoft.com)
writes:
You didn't say which syntax you are using, but I seem to recall that
this is the message you get if you do not specify "DISK =".

Here is a sample restore command:

   restore database abasec_fi_ak_ip_konv3 from disk =
     'd:\konvbackup\gripen\abasec_gr_ak_ip_konv3_051111.bak' with stats

And here is one you would use if you restore the database under a
different name:

    restore database abasec_merge from disk =    
    'd:\konvbackup\gripen\abasec_prod_prepostlude.bak' with stats,
     replace,
     move 'abasec_gri_Data' to
    'd:\program files\microsoft sql Server\MSSQL$G\data\abasec_merge.mdf',
    move 'abasec_gri_Log' to
    'l:\program files\microsoft sql Zerver\MSSQL$G\data\abasec_merge.ldf'

Read80Trace.exe in SQL Server 2005
can not find the relationship in 2005
bcp accent problem
What is SQL2005 final build number?
Query Analyzer Debuging