Post reply

restoring database

  • November 23, 2005 at 6:15 am

    #111401

    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

     

  • November 23, 2005 at 8:15 am

    #605470

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

    What result you got? 

  • November 23, 2005 at 9:06 am

    #605481

    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

  • November 23, 2005 at 9:20 pm

    #605612

    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."

  • November 23, 2005 at 11:46 pm

    #605623

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

     

     

     

     

  • November 24, 2005 at 7:31 am

    #605690

    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