July 16, 2013 at 10:13 am
Hi all,
First of all, this is development server. We have a database of a size of over 1 TB which have partitioned tables and it was restored several months ago.
Now, if I select from any table which are partitioned, it gives an error message recommending to run DBCC checkdb, and points to particular file, which I guess may be corrupted. For now I am running DBCC checktable against table in question. But my question is not about this.
I have fresh production backup. Can I restore just one file into our database? If it is possible, how should I do this restore?
Thanks.
July 16, 2013 at 10:18 am
Is the table partitioned across multiple filegroups, is this file in its own filegroup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2013 at 10:24 am
It is partitioned accross multiple filegroups, and each FG has only one file. But me error message points only to the very first file in this partition scheme.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply