Hi Jude,

There would need to be a small outage during the reply of the final logs but it would be minimal compared to the time of coping across the 2TB...

Hi Jude,

Thanks a lot for your reply. Appreciated.

My issue will be when I go to rename the DB_2 database on SQL2 to DB1 so I can add it into the...

Thanks so much for the feedback - it has solved my issue - I will patch the .net framework where I can so we can use the 'MultiSubNetFailover=True parameter and...

Thanks for getting back - yes still no closer to finding an answer to this one - Apologies for the confusion also. Yes I am referring to sys.sysindexes. If I...

Thanks a lot for this tip - I ran into the same problem where I have a report that monitors Credit Card payments and triggers if there is none in...

We have been using AlwaysOn at my company now for 12 months and the issues we face with Analysts executing long running queries on the secondary causing blocking due to...

Hi all,

Thanks for the replies. I am currently just doing tests to put a case forward for moving the Data Warehouse Team to SQL 2014 as we have having so...

Hi Kevin,

Thanks for taking the time to reply - apreciated.

To address your questions below:

1.I could look at enabling the T2371 flag again for sure - I guess where I was...

Hey Ed - Ok - that makes sense - thanks for sharing your experience with us - definite food for thought for my own work:-)

Hey Edward,

I am currently upgrading our SQL Server 2008 R2 environment to SQL Server 2012 on all new Windows 2012 servers so found this very interesting - sounds like a...

I found this......

Dedicated network adapters: For best performance, use a dedicated network adapter (network interface card) for AlwaysOn Availability Groups.

Hi Perry,

Thanks for getting back - in reality I just need to check that data in a single column is the same for each matching PK in the 2 tables.

So...

We just rolled out AlwaysOn in our reporting environment last week to replicate 2 databases from our data warehouse to allow our data analysts query the report databases without effecting...

Hi,

I am also looking for this tool today - have used it many many times in the past. I'm now on SSRS 2012 however - will it still work?

Would be...

Hi Jason / Craig,

Many thanks for the replies - I think for my pride I wanted to stick it out and try and solve it without a re-install so I...