Thanks for that - good comments

Yes we have been discussing doing this.

This was mainly to avoid downtime due to a lengthy backup/restore process..but we do have test environments to look...

Hi,

As expected your advice is spot on thanks

I was sort of thinking there may be instances where unsupported tasks could be performed and as you say...testing is not reality.

I'm not...

Ok..

So i've managed to get the server restarted

I've enabled the checkbox against the profile to send using SSL

The mails now longer send

For info the emails worked before  :(...on Port 587

Does...

Hmmm...i feared that.

thank you very much for the clarity and confirmation.

🙂

Hi

Thanks for that

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v2.0.50727]

"SystemDefaultTlsVersions"=dword:00000001

"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319]

"SystemDefaultTlsVersions"=dword:00000001

"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v2.0.50727]

"SystemDefaultTlsVersions"=dword:00000001

"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]

"SystemDefaultTlsVersions"=dword:00000001

"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]

"DisabledByDefault"=dword:00000000

"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server]

"DisabledByDefault"=dword:00000000

"Enabled"=dword:00000001

Hi,
A good discussion topic I think.
I have been having these conversation with my superiors over the last 10 year.
I have discovered that no matter how much benefit...

Thanks yes I've realized that 🙁

A slight update
I have been running a profiler against 2 instances, one that suddenly fails and a successful run.
In the instance...

Hi 
Thanks for your comments.
We are using Amazon RDS which is a little restrictive but that said we are only running procedures.
Our data is not that volatile, we...

John,

Thanks for the response.

tempdb is being consumed by internal objects only which would suggest a lot of worktables, hash matching and sorting.

There is nothing...

Hi, there are lots of articles and "how to's" around and I suggest you have a look.

I tend to use a separate account for the agents (different from the service...

Well the newer replication should support schema changes.

A safer bet is to remove the table from replication publication, make your changes, add the table to the publication, run the snapshot...

Hi,

To continue on from the good advice of the previous post.

You might want to look capacity planning.

Look at the tables that grow the quickest and the causes of this. Also...

Hi,

It sounds like you are in a bit of a mess.

Are you dealing with replicating to developer servers/machines ? Do they know the rules about replication ? When I say...

Hi,

Have you tried adding a share to the file location (and giving permissions to the share to the relevant accounts) and using that in the UNC path ?

Graeme

Hi,

Without knowing too much of your architecture, it's difficult to say.

Merge replication is designed to keep data synchronised so whatever data you put in the merge should stay in synch....