Post reply

File Group backup & restore in SQL Server 2005

  • September 2, 2010 at 2:18 am

    #157178

    I have SQL server 2005 db named DB1 there are 2 file groups FG1 & FG2. Table1 is in FG1 & Table2 is in FG2. I have accedently dropped Table1. I have full backup, FG1 & FG2 file groups backup & transactional backup. I want to restore FG1. How can I do this ? Please tell me how to restore this FG1 file group.

    Thanks in advance!

  • September 2, 2010 at 2:35 am

    #1215443

    is this a live db???

    If yes then restore everything on a standby server and then script out this table... create table with all constraints and then import the data...

    else you can put the db in dbo mode and then restore the file group backup then all the subsequent tlog backups and then the last backup after deletion with stop at mark..... if you need this table data to be point n time...

    Rohit

  • September 2, 2010 at 6:52 am

    #1215559

    It is not live data I am practicing. Can I restore only that FG, from where the table got deleted. Else I need to restore all backups including full backup then all FG backups then all transaction backup.

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

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