Can you check the is_trustworthy_on setting on the PRIMARY and then on the secondary. This needs to be set to ON. It is off by default on the secondary from...

Can you post the results from the query below.

PLEASE TEST ANY QUERIES BEFORE RUNNING ON LIVE.

SELECT files.physical_name, files.name,
stats.num_of_writes, (1.0 * stats.io_stall_write_ms /...

You will need to run CHECKDB on the restored database on the TEST environment. First indications would point to some sort of corruption. I will look for any I/O related...

I would say from the limited information supplied. The request is coming from another domain which has no domain trust in place with the destination domain. Is there a domain...

I would say that is not long enough to decide whether the INDEX is useful. I like to have stats for a least 3 months before making any sort of...

select * from sys.dm_db_task_space_usage
where internal_objects_alloc_page_count <> 0

See what has allocated pages and not deallocated pages.

If DBCC OPENTRAN also shows nothing it could be a deferred...

I believe the protocol is setup @the domain level not per account.
KERBEROS is the preferred method, Some forget to set up DELGATION AND SPNs correctly when opting for...

Me for 1. I don't care who got there first. I got a useful script I wasn't aware I needed until now.
NICE 1 and a good question S_KUMAR_S.

I think that's for the WINDOWS specialist NOT a SQL DBA.
This is how they are authenticating around the domain NOT SQL specific.

As far as I am aware...

#or create something exactly the same within minutes that works

I would drop the Database Maintenance Plan and recreate it. I have seen this many times before DMPS are prone to this. You can spend hours trying to figure out...

Thanks for all the advice guys.

Simple audit who change what when and to what.
From a few years back I remember reading that INSERTED UPDATED and DELETED are not all needed.
What I'm trying to...

Are the reports parameters vastly different and therefore returning varying data sets sizes. Such as a Date To and Date From parameter?

This would explain time processing. Or are...

No worries, You owe me one solution to the next issue I post Grant. Then all is forgiven.