Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: cannot restore a backup database

    hi all,

    i just learned mssql server and need help form u guys the experts. i made a backup of database but i couldnt restore it into another machine.
    the original database name is "employee" and running in mssql 7. the target database is named "employee" as well and running in mssql 2000.
    it gave me this message:

    Microsoft SQL-DMO (ODBC SQLState: 42000)

    Cannot find file ID 2 on the device 'C:\db_bak\employee.dat'.
    RESTORE DATABASE is terminating abnormally.

    i tried to restore it to another mssql 7 but it gave me the same error message. i dont know how to fix it. in the sql server log, nothing refers to the restore activity. please help....

    thanx in advance,


  2. #2
    Join Date
    Feb 2004
    Bangalore, India
    in mssql2000 i faced a similar problem.

    but the problem was solved when i gave the correct path name for the data and log file.(installation directory\data path)


Posting Permissions

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