locked
Restore Files. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Everyone,

    I have a database say DB1 having 2 data files and 1 log Files.

    My objective is to restore a file of a DB1 using the backup ( Only that specified file will be backed up and restored to another database).

    For that what I did ,

    1. backed up the file (say mdf)  using file and filegroup option.

    2. tried to restore the file in another database DB2, When I did this I got an error that File 2 was not backed up.

    Please advise how to accomplish this task.

     

    Thanks in advance

     

    Regards,

    Ranjith Kumar

    Ranjith Kumar Mohandas
    Thursday, March 3, 2011 6:49 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi Ranjith,

    As per my knowledge to do so we would require that DB2 should be created from a full backup of DB1 and that you have the filegroup backup and all of the Transaction Log Backups from the full that created DB2 to bring the database and filegroup to a consistent state. 

    You can find Brent's Vedio to be more useful.

    Thanks & Regards, Pramilarani.R
    • Marked as answer by Papy Normand Tuesday, March 8, 2011 7:13 PM
    Thursday, March 3, 2011 11:26 AM

All replies

  • Question
    Sign in to vote
    4
    Sign in to vote

    Hi Ranjith,

    I hope you are restoring the database DB1 file backup on to the database DB2 where the database is different and its logical& physical structure will also be different. You can restore the DB1 file backup to DB1 database.


    If you are trying to know this concept you can click here to know more details about it.

    Thanks & Regards, Pramilarani.R
    • Proposed as answer by DBA_Ramya Friday, March 4, 2011 4:48 AM
    Thursday, March 3, 2011 7:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Pramilarani,

    Yes you are right. I am trying to do that but is there any other way to do that or any option for that?

     

    Thanks.

    Regards,

    Ranjith Kumar

     

    Ranjith Kumar Mohandas
    Thursday, March 3, 2011 7:44 AM
  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi Ranjith,

    As per my knowledge to do so we would require that DB2 should be created from a full backup of DB1 and that you have the filegroup backup and all of the Transaction Log Backups from the full that created DB2 to bring the database and filegroup to a consistent state. 

    You can find Brent's Vedio to be more useful.

    Thanks & Regards, Pramilarani.R
    • Marked as answer by Papy Normand Tuesday, March 8, 2011 7:13 PM
    Thursday, March 3, 2011 11:26 AM