Restore a single partition SQLServer2005
I want to to restore a specific filegroup to a prior point in time, but leave the remaining filegroups current.
Assume a 100 partition table which is updated by a job which updates data in one partition - say a monthly job. The specific filegroup is backed up prior to the changes. An error occurs then we want to restore only that one partition back a few hours or a day or so, but do not want to touch any other partition - they are all OK.
So far, it seems that i have to restore and roll forward to the current time - including PRIMARY filegroup or i can restore the whole database back to a point in time.
Any help is appreciated.
Thanks
Glenn
[686 byte] By [
Glennn] at [2007-12-25]
Filegroups cannot be restored to a prior point in time. They and the partitions they contain are not self contained in that there is still metadata references in the primary filegroup which need to kept consistent. -- Peter Byrne Microsoft SQL Server Storage Engine This posting is provided "AS IS" with no warranties, and confers no rights.
wrote in message news:dabe1514-50ac-4cac-88a0-0fa0afaafa94@discussions.microsoft.com... >I want to to restore a specific filegroup to a prior point in time, but
> leave the remaining filegroups current. >
> Assume a 100 partition table which is updated by a job which updates
> data in one partition - say a monthly job. The specific filegroup is
> backed up prior to the changes. An error occurs then we want to restore
> only that one partition back a few hours or a day or so, but do not want
> to touch any other partition - they are all OK. >
> So far, it seems that i have to restore and roll forward to the current
> time - including PRIMARY filegroup or i can restore the whole database
> back to a point in time. >
> Any help is appreciated. >
> Thanks >
> Glenn >
> 