What networking restrictions are there in place, there are a number of ports required for the nodes to fully communicate, are there any firewall devices

transactions should be as short as possible, performing lookup work mid transaction will always cause concurrency issues.

What makes you think locking the whole table is better when a row or...

Did you ever find the solution? If so, would you be kind enough...

try working with your storage admins firstly

No! Definitely dont do this, besides the fact you shouldnt restore...

Agent log has the following 4 entries at the time of failure:

[298] SQLServer Error: 26, Client unable to establish connection because an error was encountered during handshakes before login....

whats in the sql log

have you double checked the auth type on the instance to ensure it's still mixed mode.

If someone changed it and then a restart occurred down the line the new auth...

In the interest of helping others who visit the site facing the same problem, just provide a short description of how you...

heres some code you may find useful

http://blog.perrywhittle.co.uk/post/2024/06/25/Restore-database-code.aspx

I have a script depending on exactly what you need to do

Not clear what you require, if you backup dbs to shared drive and want to restore from there why do you want to change the path.

Do you mean you want...

32 vcpu is excessive on any vm, at the very least the host cpu scheduler will have hard time scheduling the vcpus unless you’ve been smart with vm placement

ah right so Comedy Central not sql server central.

if I were...

that's incorrect. It's not links to files. It's streamed a file into a hidden/inaccessable place in the file system that can be read back from t-sql and a win32...