Post reply

FileGroup restore

  • October 5, 2012 at 1:57 pm

    #393325

    Hi,

    I am trying to restore filegroups from full backup. Restore primary with partial and applied the all the filegroup restores. After finishing all the restores when i to do count(*) on the table i get the following error--

    One of the partitions of index 'idx_'for table 'dbo.Demo'(partition ID 72057594040549376) resides on a filegroup ("Data") that cannot be accessed because it is offline, restoring, or defunct. This may limit the query result.

  • October 5, 2012 at 2:29 pm

    #1546313

    You need to restore all log backups from the oldest of the filgroup backups you restored right up to the latest, so that you can bring the entire DB to a single point in time.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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