Thanks Sue_H

I have come across that link...but I understood it a different way...issues related to queries that are run on secondary server (for eg: if you have redirected...

Thanks for the response.

Will look into increasing Tempdb

Hi Perry

Unfortunately I'm not sure on the usage as the query is in a SQL job that runs in the early hours of the morning.

Hi

No graphs or images just tabular data.

I've not tested it in report builder...

Was told to test latest sp...getting that installed

Thanks Gail...the reason we are going for this option (restoring) is because there's not much down time. So to ensure as little down time as possible I thought this would...

Thanks for your response.

Yes...its very random.

Hi all

Yes the install paths will be the same.

This plan will be tested first on a qa server.

The reason for this plan is to ensure migration is as seamless as...

Hi guys,

Thanks for the replies.

This environments has no certificates.

Regarding the maintenance plans, logins etc...by moving the current Master and Msbd...this should be covered.

There also no Smk being used.

Thanks again guys...

Hi All,

The issue I experienced has been resolved. The afternoon of the day I posted this topic, there was an issue on that server that required my colleague to run...

I've used the DMV sys.dm_exec_sessions and they both (the SELECT and UPATE) have an isolation level of Repeatable

It seems this is where I need to start investigating

I ran dbcc useroptions to get this - isolation level = read committed

That is what's got me so confused. There is no link at all between these 2 tables...I do not understand the reason for the SELECT to block an UPDATE on...

Hi Dev,

No...it's a table...and so is AML