So If you want a way to join two SQL environments together with SQL Always on availability groups, maybe these environments are on different OS versions which makes stringing a...

Brilliant Thanks Eddie

Many thanks for your reply.  I will take a look.

Thanks for the reply,  These databases do exist and it all worked up until recently, plus the fact that accounts that once worked no longer work to access the instance...

Sorry i just used a standard instance name so as not to give away the real information  I am using the named instance with the port number.  for example /INSTANCENAME=MSSQLSERVER,...

Yes it is.

The following script can be used to set up log shipping standard and Disconnected log shipping but for the purpose of Disconnected log shipping, I have modified it slightly.

I recommend...

I fear you believe my question to be simplistic in nature hence the response.  I have reviewed posts many in fact and the script you mention is not really what...

Hi Steve,

So the background is the log files are being Tlog shipped from an external company once a day to a file share.  This external company has provided us with...

Agree with you comments relating to the secondary node being read only will incur additional licensing costs as the SA purchased with the primary server will give you one free...

Hi there.  I am in agreement with the rest about adding a third node however I am guessing that your reason for suggesting this is down to cost which is...

That seems like a lot for a 60gb dB. That said the most I have migrated was around 30 file groups per database. I simply restored a backupof the said...

Not really a problem but there are 5 access databases and one SQL Server on prem.  A job has been created on the SQL Server to export data from these...

I believe that is all you require.  As per Steve Jones's Post go 2017 if you can however it all depend on what you will be hosting on an availability...

Hi sue,

That at is correct however the issue is that when you assign available storage to a role it no longer appears in the cluster storage as a volume that...