Retore Filegroup

• kenymaciel

  Old Hand

  Points: 338

  More actions

  October 11, 2019 at 3:45 pm

  #3688081

  HI,

  I have a database with two filegroup, PRIMARY and FG_FTS.

  In filegroup FG_FTS I leave full text search.

  If I only back up filegroup PRIMARY, if I lose my production base can I restore filegroup PRIMARY and then create another filegroup and recreate full text search?

  Thanks.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 12, 2019 at 4:10 pm

  #3688235

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• prettsons

  SSCertifiable

  Points: 7453

  More actions

  October 14, 2019 at 9:12 am

  #3688430

  There are a few limitations for restoring the filegroup:

  • The system administrator restoring the files and filegroups must be the only person currently using the database to be restored.
  • RESTORE is not allowed in an explicit or implicit transaction.
  • Under the simple recovery model, the file must belong to a read-only filegroup.

  Read the complete process here: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-files-and-filegroups-sql-server?view=sql-server-ver15

  SQL Database Recovery Expert 🙂

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 14, 2019 at 10:39 am

  #3688447

  Best thing to do is test it in your Dev or sandbox environment.