Post reply

Piecemeal Restore in sql server

  • 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.

  • 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

  • November 2, 2010 at 10:11 pm

    #1245839

    Thanks Carl.

    Can you elaborate this please.

    Regards,

    Ravichandra.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply