Yep. It is set on each node of the cluster.

Nope. I've switched that off to make sure it's not interfering.

I restarted the SQL Server services a few times and this didn't solve the issue. I then failed the...

Ok now I am more confused.

I just logged on the server to do some more testing and simple executed a "create database test" command with no other parameters. The model...

Thanks for your reply. I can't fathom it either and cannot replicate it on any of my other servers, only this one.

I've just tested again and kept an eye...

Can you change the SQL server to run under a dedicated account rather then system account? Then you should be able to set up the share to have write access...

Aha! I am an idiot. I had set the user up as a sysadmin as the app needed that permission when moving over to the new server. This will default...

Thanks for the reply.

Ah, interesting. So I am connecting as DBO for both user and schema, yet on the original instance I connect as webuser for both user and schema.

Hmmm.....

Just to follow this up.

After a number of calls with MS Premier Support, they finally worked out what I was talking about, despite constantly trying to suggest I was using...

Thanks for your help.

I've logged a premier support call with Microsoft and they believe it may be an issue with AD, rather than SQL, so have passed me onto their...

No problem. Thanks for your help.

We found setting up the MSAs quite easy, so I do worry we have missed something! 😀

The server is not clustered.

It has two...

Thanks for the reply. I understand what you are saying, but the service is using a managed service account, rather than a normal user with a password. The passwords...

Ah! That makes perfect sense when you think about the redo overhead! I am not sure why we have the DB in standby mode. We do not report on it...

As a side note. Logs are taking about 20 minutes to restore for a 50 MB file. The number of changes is around 4800 inserts during the two...

Log shipping for the database was configured in Standby/readonly mode, but the DB is in restore mode when it is restoring the transaction logs. When it falls behind, because...

Yep, the page file was configure just on the C: drive.

Datafiles are configured on the d:Logfiles are configured on e:Tempdb is configured on t:

I couldn't see anything on the...