March 16, 2012 at 4:12 am
Scenario :
I have a database "fgr" with three filegroup.
1. Primary
2. Fg1
3 Fg2
I have three table associated with those three filegroup.
1. t_primary on Primary filegroup
2. t_fg1 on Fg1 filegroup
3. t_fg2 on Fg2 file group
I have taken each file group backup separately.
Problem :
Accidentally I drop t_fg2 table. Could I restore single Fg2 file group without restoring primary & Fg1 filegroup? If yes, then how could I restore?
Please help.
March 16, 2012 at 4:15 am
Yes, but...
While you could restore Fg2 separately (providing the DB's in full recovery and you're running Enterprise Edition), you'd have to then restore log backups to bring the filegroup up to date with the rest of the DB, and that would replay the drop table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2012 at 4:26 am
If I'll apply the log backup that I have taken before dropping the table, do I able to recover the drop table.?
March 16, 2012 at 4:28 am
No, as I said you'd have to apply log backups to bring the restored filegroup up to exactly the same point as the rest of the DB, and that would replay the drop table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply