Thank you!

1 )So since FCI doesn't use a replica, there's no cost pertaining to the passive server... But since we use database mirroring, a replica will take its place....

Back to the primary site and fully online.

Does anyone that has encountered this issue think that I should redo my mirror to possibly fix the RESTORING status when...

The database is online except for those two data files.

I am planning on failing back to the primary site and taking a differential and full backup.

I'm...

The differential and full backups are failing because two data files are stuck in RESTORING state. I have manually taken a transaction log backup to the differential backup folder...

I guess I'm the only one who has encountered something like this?

Great... 🙁

No one has any ideas on how to fix this?

I was doing index rebuilds online (yesterday) and had to cancel them due to blocking. I think that's the reason for the extra sys.partitions records. There wasn't an...

Ah, sorry. Here's the query:

select *

from sys.dm_db_partition_stats a

right join sys.partitions b

on a.partition_id = b.partition_id

WHERE b.object_id = OBJECT_ID('tableA')

The results:

partition_idobject_idindex_idpartition_numberin_row_data_page_countin_row_used_page_countin_row_reserved_page_countlob_used_page_countlob_reserved_page_countrow_overflow_used_page_countrow_overflow_reserved_page_countused_page_countreserved_page_countrow_countpartition_idobject_idindex_idpartition_numberhobt_idrowsfilestream_filegroup_iddata_compressiondata_compression_desc

7205760239081881612271514175137233750376000003750376018444957205760239081881612271514175172057602390818816184449501ROW

NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277689139212271514171172057602776891392184247401ROW

NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277695692812271514171172057602776956928184247401ROW

NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277793996812271514171172057602777939968184249801ROW

NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277807104012271514171172057602778071040184265801ROW

NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760278259302412271514176172057602782593024184294401ROW

7205760278370713612271514171137453780385000003780385018444957205760278370713612271514171172057602783707136184449501ROW

7205760278377267212271514176144854517453000004517453018444957205760278377267212271514176172057602783772672184449501ROW

Oh jeez... That's not easy to read. Is there...

I'm wondering since the table is constantly being queried, will the clean-up of sys.partitions not occur?

Looking for help...

Ok, I just rebuilt the index and I still have the extra records in sys.partitions.

Does anyone know how to clean this up?

Thank you.

I noticed that I was attempting to rebuild the index, but since it was being queried constantly, I had to cancel. I think that's what is causing the sys.partitions...

Thank you for your response.

That's what I thought (the checks occur before the trigger firing), but I couldn't find that info in writing anywhere. Unfortunately, the [ColumnB] is used...

Got it to work, but when I add it to the Mirroring Monitor, I get the error message:

SQL Server replication requires the...

Can you please explain how best to do that?

That's what it was originally (before...