I was able to get the bad plan out of the plan cache and found that for some reason my dynamic SQL is not respecting my partition and thus trying...

Thanks for your help, the full final script has been posted on my blog: A Few Changes In SQL Server 2012 (DBCC LOGINFO and DBCC CHECKDB)[/url]

Edward, thank you for your response. This worked perfectly.

Apparently others have had this same problem, with no solution: http://www.sqlservercentral.com/Forums/Topic1304211-391-1.aspx

Unfortunately, the cluster group does not exist any longer, nor is there any other place in Failover Cluster Manager that lists "Orphaned Resource" or anything like that.

Windows Version: Windows Server...

Yes, I have sufficient backups, IF the corruption happened within a proper...

The view is not indexed, everything is SQL 2008 Enterprise.

The view is:

CREATE VIEW [data_calc].[vw_Data]

WITH SCHEMABINDING

AS

SELECT [identifier], [maxVersionTsUtc],[maxVersionTsUtc_value],[dataPointIdentifier],[elementIdentifier],[intervalUtc],[sequenceNumber],[rootFlowdayNumber]

FROM [data_calc].[tbl_Data_ERNDL_2011] (NOLOCK)

UNION ALL

SELECT [identifier], [maxVersionTsUtc],[maxVersionTsUtc_value],[dataPointIdentifier],[elementIdentifier],[intervalUtc],[sequenceNumber],[rootFlowdayNumber]

FROM [data_calc].[tbl_Data_ERZNL_2012] (NOLOCK)

UNION ALL

SELECT [identifier], [maxVersionTsUtc],[maxVersionTsUtc_value],[dataPointIdentifier],[elementIdentifier],[intervalUtc],[sequenceNumber],[rootFlowdayNumber]

FROM [data_calc].[tbl_Data_ERNDL_2012] (NOLOCK)

UNION ALL

SELECT...

Will do, as soon as the devs get back to me. I'll run the query before and after and post plans from each.

Unfortunately, I would have to get my devs to give me an elementIdentifier list and datapointIdentifier list. I am sending them an e-mail asking for said information, but unfortunately...

Agreed, I cannot see how any of that would matter. Maybe RedGate will have some better insight. I will package all this up and send it off to...

yeah, I was just thinking about that. The configurations for each are identical in the "HyperBac Configuration Manager", so I don't see how it could matter

OK, so I picked this back up this morning and compared the two methods: A) Using the VR Wizard, which works, and B) Using my method, which generates a restore...

Well, the virtual restore worked just fine using the wizard, I am going to look at my generated restore script as compared to the script generated by the wizard and...

Yes, almost every database in my shop backs up to multiple files, some more than others, some less. In any regard, I will try doing the restore using the...

I appreciate the input on the quick-fix idea. That would be no problem, but since this is an important failover instance, I would like to explore what may have...