If anybody is interested I came across this that recommends using the blocked process report in EX:

http://www.sqlskills.com/blogs/joe/tracking-isolation-level/

Its annoying that the extended event transaction information doesnt extend to isolation...

Anyone? There must be a way?

Stick it in double quotes if you run into this 🙂

Nobody run into this?

RPC_Completed will only fire if there are no errors

Do you not need to put RPC_started?

Chris

Any joy with this? Ive got the same problem?

So the network copy from B to C was corrupted

Process has been changed and a CHECKSUM is being used in the BACKUP with compression and striping

thanks to all who...

I ran a DBCC CHECKDB on B and its fine with different data(correct) in that row than on C. So Im happy with the data in the primary

The same backup...

Thanks...back to the drawing board!

Im having the same issue where I thought picemeal was going to be quicker

I am developing a DR solution and one of the things Im testing is peacemeal restore as...

Thanks Grant. Meant to get back to this but have been swamped

It seems Im going to have to get my hands dirty with XQuery to get what I want which...

We are using AlwaysOn to a DR site so we do have High Availability

The 2 hour restore is if we lose both it has to be available within 2 hours

Overkill?

There is a business requirement that the database needs to be opreational within 2 hours if it is lost

Partitioning is so we can recover the latest filegroups and files ...

Hi Guys

Thanks for your responses. I just wanted to clarify my position

So i started here 3 weeks ago on a system thats been developed in c# and t-sql(supposedly agile but...

I dont think Im being clear

I know how to get it to run(add a linked server) but my question is how can

this code run successfully:

SELECT 1

FROM EWH_Staging.dbo.STAGE_REMP_VCC_Distinct vcc

It should...