How to restore only 1 file group as a new database

• Bimal Fernando

  SSCommitted

  Points: 1945

  More actions

  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

• EdVassie

  SSC Guru

  Points: 60527

  More actions

  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

• Bimal Fernando

  SSCommitted

  Points: 1945

  More actions

  September 22, 2004 at 5:12 pm

  #524087

  Thanks