Thanks Jeff for the article, I am going through it.

FYI, there was below changes made so far - though still no improvements.

Rebuild indexes and update statistics to reduce fragmentations

Max degree...

Hi Jonanthan,

No we cannot set it to SQL-2008 as a company standard

Thanks for the response Steve.

FYI, I am trying this on SQL Server 2016 Dev edition.

Here is the command I use:

CREATE DATABASE [TEST_SNAPSHOT] ON

(NAME = N'TEST_DB', FILENAME = N'C:\DBFolder\TEST_SNAP.snap'),

(NAME = N'TEST_DB_1',...

Any pointers on this would be helpful.

Yes I realised this as well, I connected to Standard & Enterprise it worked. Thanks for the response

Thanks Fred, I will work around this.

Thanks for the Feedback Steve..

If the password changes, do you mean the password for the backup of the cert? Or the certificate itself? If you have the certificate...

@GrumpyDBA , how did you track it , using MSDTC trace log ?.

Did increase of timeout solve the issue for you?

Many Thanks for your quick replies on my thread, below are inline comments...

1. Find out from your vendor if your 2008 r2 SQL Server is indeed separate from your 2005...

We have SQL Server hosted on different physical server managed entirely by different vendors.

You mean .net 3.5.1 is required on sql server box as well ?...

I have tried DTCPing between...

The .net 3.5.1 role is already enabled on our App server.

Yes, I will do it on test environment, I think the roles are already added , but let me cross check once.

You mean just change the IIS .net framework to 3.5 and try? , we have not done this as all our .net dll's are built in .net 2.0 framework...

So...

No , moving it to new physical server where SQL Server 2008 r2 is installed ,its an clustered environment.

I know that option, but want to know if SQL Server supports redirection to different database.

Issue is we dont have control over the SQL servers and there are lot of...