Wednesday, March 7, 2012

restoring filegroup from different date than mdf file

Can anyone tell me what the effect would be of restoring a filegroup from an
older date than the other filegroups in the database.
The tables in the older filegroup contain fewer records than the current
one. My main concern is that the sysindexes table will still contain
reference to a greater number of records.You would not be able to access the database until you have restore all subsequent transaction log
backups for the database until current point in time. This is better explained in Books Online...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:475C96EA-967D-4200-95ED-F1038F4488E0@.microsoft.com...
> Can anyone tell me what the effect would be of restoring a filegroup from an
> older date than the other filegroups in the database.
> The tables in the older filegroup contain fewer records than the current
> one. My main concern is that the sysindexes table will still contain
> reference to a greater number of records.

No comments:

Post a Comment