Post reply

How to restore only 1 file group as a new database

  • September 20, 2004 at 10:16 pm

    #83984

    These are the 3 Logical file names in my database.

    DB1_Data -- Primary Data file (Primary File Group) --> File1.mdf

    Large_Data -- Additional File ( New File Group) --> File2.ndf

    DB1_Log -- Log File --> File3.ldf

    I have just backed up the Primary data File using the following command

    backup database XXX FILE = 'DB1_Data'

    to disk = 'C:\DELETE_ME\Prim_Data.BAK'

    with init, stats=10

    I don't have a backup for the Additional File (File2.ndf)

    Is there a way i can restore only the backup i have taken above in to a new database so that i can see the objects inside that File Group (Primary) only.

    Thanks in advance

  • September 22, 2004 at 4:42 am

    #523944

    If you use SQLBackTrack backup/recovery software from BMC, this can be done.  With standard SQL Server backup/recovery the answer is no.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • September 22, 2004 at 5:12 pm

    #524087

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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