I went through the below article which says about rollback processs happens in stand by mode which I am not sure. One other thing is in stand by it has...

Hi Ed,

I want to know the syntax of SFTP command that will execute by sql server job and what steps will I have to follow to do public key authentication...

Hi Nitin,

I am also looking for the same solution- using SFTP move the files between windows Servers and implementing by TSQL in SQL job. Cna you please share your solution...

The two servers are not in network they are on AWS cloud( two diff Virtual servers with no dns names)

No file sharing port is open between the servers.

Replication cannot be...

1.Check with you AD team managing smtp server, to see if there is any restriction on any policy effecting you

2.Check connectivity between the server & smtp server is persistant or...

Does the new Service account is added in the Local administrator group on both the servers (Primary and seconday)?

When i execute this statement i am getting the below error message:

INSERT INTO dbo.[DB Mirroring State Changes] (

[Event Time],

...

One more thing to add, the servers are Virtual (Principal, Mirror and witness).

But increasing the response time might not give us the actual root cause why it happened.

I am looking more into I/O error what we received- looks to be DISK I/O...

Perry,

I was not able to follow this statement, can you please elaborate--

The key to remember here is how the clustered instances will be distributed, just because you install a clustered...

Not sure. Wait for Perry's reply.

Also can somebody explain me this sentence--

•If you have linked servers running distributed transactions, then MS DTC is required.

We have linked servers established from cluster server to other non...

Hi Gila,

I have set cost threshold of parallelism to 15 based on subtree cost of the queries.

how can i find particular spid in sql server which is consuming more cpu?

PID...

Jay,

We tested it on the dev servers and we never had any issue with shared drives. We never restarted the service. I am not sure why you wanted to do...

I guess there's no need to restart the server after adding the disk as dependency.