restoring database

  • Hello all,

    I have a database backup in .BAK format and i need to restore it to server.

    I tried

    RESTORE DATABASE sglue_md

    FROM DISK = 'C:\sglue_md_20050804b.bak'

    WITH REPLACE, MOVE 'DBName_Data' TO 'C:\MSSQL\DATA\sglue_md_Data.MDF',

    MOVE 'sglue_md_Log' TO 'C:\MSSQL\DATA\sglue_md_Log.LDF'

    But i got the following error

    Server: Msg 3234, Level 16, State 2, Line 1

    Logical file 'sglue_md' is not part of database 'sglue_md'. Use

    RESTORE FILELISTONLY to list the logical file names.

    Server: Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Can someone tell me how I can use the .bak file to copy the database to the server?

    Thanks in advance,

    Sunil

     

  • As the error message suggested, did you run RESTORE FILELISTONLY?

    What result you got? 

  • Alternatively Enterprise manager would be helpful.

    On the restore screen replace the default which is the file location from which the .BAK was  created with the new file location...

     

    Mike

  • Hello,

    I used restore filelistonly and i got

    sglue_md_Data g:\MSSQL\Data\sglue_md_Data.MDF D PRIMARY 10329063424

    sglue_md_Log g:\MSSQL\Data\sglue_md_Log.MDF L NULL 1048576

    And i used enterprise manager to restore the database and i am getting "internal consistency error. contact microsoft support."

  • Pls recheck u r logical file names 'DBName_Data'  and 'sglue_md_Log' in restore command . May be these logical files names are wrong.

     

     

     

     

  • In the command of your original post,

    RESTORE DATABASE sglue_md

    FROM DISK = 'C:\sglue_md_20050804b.bak'

    WITH REPLACE, MOVE 'DBName_Data' TO 'C:\MSSQL\DATA\sglue_md_Data.MDF',

    MOVE 'sglue_md_Log' TO 'C:\MSSQL\DATA\sglue_md_Log.LDF'

     

    The logical filename for data file is 'DBName_Data', which should be 'sglue_md_Data'

    Since you already tried in enterprise manager and got an 'internal consistency error' error, it seems the backup files are corrupted.

     

Viewing 6 posts - 1 through 5 (of 5 total)

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