Piecemeal Restore in sql server

• ravisamigo

  SSCertifiable

  Points: 7440

  More actions

  November 2, 2010 at 1:55 am

  #230615

  Dear All ,

  What is the use of Piecemeal Restore in sql server, because we already have another method file group restoring...

  could you please tell me the basic difference between them ?

  Thanks and Regards,

  Ravichandra.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  November 2, 2010 at 3:45 am

  #1245245

  In a Piecemeal Restore scenario, after the primary file group is restored, the database can be brought on-line with any secondary file groups that have not been restored being offline. While the database is online, the secondary file groups can then be restored and brought on-line.

  SQL = Scarcely Qualifies as a Language

• ravisamigo

  SSCertifiable

  Points: 7440

  More actions

  November 2, 2010 at 10:11 pm

  #1245839

  Thanks Carl.

  Can you elaborate this please.

  Regards,

  Ravichandra.