Post reply

Restoring a partitioned database without archive partition

  • June 30, 2010 at 9:07 pm

    #234619

    Hi,

    I have a production database with some of the bigger tables partitioned.

    I need to restore the database into a dev server without some of the filegroups where the old data is, so to keep the database small and the restore quick.

    After the restore I am getting some error messages about unavailable filegroup(s) when running queries like "select * from mypartitionedtable".

    I need the database without the archive partition and I need this to be transparent to the application as is that filegroup has never been there.

    I was thinking of restoring the entire database, then truncating the data which belongs in the archive filegroup and then doing filegroup restore without the archive filegroup.

    Any ideas?

  • July 5, 2010 at 8:21 am

    #1188787

    I have exactly the same issue. I only want to restore the primary partition (10gb) and not the whole 200gb database spread across multiple filegroups.

    It doesn't seem to be possible as performing a 'select *' will try and read from all the partitions.

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

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