August 1, 2025 at 9:00 am
Comments posted to this topic are about the item How to safely and surgically restore filegroups
August 2, 2025 at 9:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 1, 2025 at 3:47 pm
Simple and to the point, thank you. Another interesting exercise would be where you have a table partitioned across file groups. It would be interesting to see how restoring (for example) 2/3 file groups would affect a query against that table.
----------------------------------------------------
November 1, 2025 at 6:06 pm
Good article. Thanks for taking the time to write it up.
What I'd like to see is...
You have a database that has a partitioned table. The partitioned table has 1 filegroup with 1 file for every month for the last 10 years.
How to restore that database to a Development Environment keeping only the previous 3 months, the current month, and the next month AND being able to back it up. It's my understanding that you cannot do a full backup unless all partitions are restored and you can't change partition allocations until all partitions have been restored, as well.
If that cannot be done (I'd love to learn how, if it can) with a partitioned table, that makes seriously good points about using the good ol' fashioned partitioned views (IMHO),
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply