Post reply

File & Filegroup restore problem

  • July 18, 2012 at 12:49 am

    #259576

    Hi,

    I have recently restored a filegroup from a filegroup backup, after then when i try to query from the same filegroup object it is showing the below error-

    'The query processor is unable to produce a plan for the table or view 'testbckp' because the table resides in a filegroup which is not online.'

    please help me resolving this error asap.

    Thanks & Regards

    Rahul Singh

  • July 18, 2012 at 1:03 am

    #1514023

    You haven't completely restored the filegroup. Without knowing what you did in the restore, hard to say what need doing, but that restore process isn't finished or it failed.

    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

  • July 18, 2012 at 1:11 am

    #1514027

    Did you follow this?

    Restore Files and Filegroups (SQL Server)

    http://msdn.microsoft.com/en-us/library/aa337540

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

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