Ah, ok, I have never run into this issue in the past, but will keep it in mind should I encounter it.

MS recommendations is to filter out anything with a page count less than 1000

Then reorg anything less than 30% fragmented and rebuild anything greater than 30% fragmented.

SELECT

case when avg_fragmentation_in_percent...

Generally I put 0 in TCP Dynamic Ports for all of the IP segments except IPAll.

Whats the page count of the indexes still fragmented and what are the index types?

SELECT object_name(IPS.object_id) AS [TableName],

SI.name AS [IndexName],

IPS.Index_type_desc,

IPS.avg_fragmentation_in_percent,

IPS.avg_fragment_size_in_pages,

IPS.avg_page_space_used_in_percent,

IPS.record_count,

IPS.ghost_record_count,

IPS.fragment_count,

IPS.avg_fragment_size_in_pages

FROM sys.dm_db_index_physical_stats(db_id(N'PCSTESTDBV2_11042015'), null,...

What are you trying to display?

Care to post your logs, obfuscated of course for any critical information, the status messages should get logged

Also take a look at https://msdn.microsoft.com/en-us/library/ms365781.aspx for tips on monitoring mirroring.

select max(repdate) from @tempdat where repdate < @StartDate

There should be an entry in the SQL log when it disconnects

Remote working an option?

structure

Take a look at sys.database_mirroring specifically the mirroring state column

I can't make heads nor tails of your sample data.

Can you please take a look at the link in my signature on posting code and data for the best help,...

This produces the result set required.

create table #quotedetail (QuoteNum int, Brand varchar(10))

INSERT INTO #quotedetail values

(10047,'NISSAN'),

(10048,'TOYOTA'),

(10049,'TOYOTA'),

(10050,'BOBCAT'),

(10050,'JOHN DEERE'),

(10050,'KAWASAKI'),

(10050,'MANITOU'),

(10050,'POLARIS'),

(10050,'SKYLARK'),

(10051,'DOOSAN'),

(10051,'MITSUBISHI')

select * from #quotedetail

Select distinct QD2.QuoteNum,

substring(

...

Can you post screenshots of your TCP/IP configuration

The transfer logins task can copy the logins and SIDs, but not the passwords. It copies the logins with a random password and it also disables the login.

The best...