Restoring a specific file group

• PradeepVallabh

  SSC Eights!

  Points: 987

  More actions

  August 27, 2010 at 4:00 pm

  #237257

  Can i restore a specific file group in SQL Server 2005???(Instead of whole backup)

  Regards,

  Pradeep

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  August 27, 2010 at 4:03 pm

  #1213314

  Yes, potentially. Do you have a filegroup backup?

  http://msdn.microsoft.com/en-us/library/aa337540.aspx