DB backup/restore without filestream

• Krishna1

  Hall of Fame

  Points: 3666

  More actions

  November 8, 2012 at 4:33 am

  #264495

  Dear All

  I have DB with Filestream. Recovery model for this is set to FULL.

  I need to backup only primary group. No need of backing up filestream folder as it will be taken care by the filesystem back up.

  I am taking backup using following command-

  BACKUP DATABASE 'dbname ' FILEGROUP = 'PRIMARY' TO DISK = 'C:\xx.bk' WITH INIT, NAME= 'xx', NOSKIP, NOFORMAT

  How do i do restore the primary group??

  Thanks and Regards

  Shilpa