You can go directly to the latest service pack - and I would also recommend applying the latest available CU for that service pack.

And yes - when applying to any...

To move cluster resources to another node - you only need to issue Move-ClusterGroup.  You don't need to suspend prior to moving the group...but you do have to issue the...

When you define the file connection - you have the opportunity to define the column headers and rename them.  The file connection then maintains the column header information as meta...

Slight modification...

1. Remove DB from BAG
2. Modify locations on primary (ALTER DATABASE)
3. Take database on primary offline
4. Move MDF/LDF files to appropriate locations as set in item 2
5. Bring database...

I had a similar issue - which turned out to be an issue in how the application was managing the connection on the web server.  The transaction was open, retaining...

I am assuming that you would need to redeploy the listener due to IP address changes?  If not - then I am not clear why it would have to be...

Another option:

 Select *
   From #tsttable t
  Where Not (t.cid In (100, 111) And t.ccode In ('out', 'outa', 'stt', 'cnty'));

I was not aware of read-scale - interesting concept.  What I found from a quick scan:

Connect to read-only secondary replicas
You can connect to read-only secondary replicas in...

Thanks for reply. But I don't care about size. My problem is state before COB. Before COB backup must not contain any transactions, because by our business policy, if...

Not sure I understand what a 'read scale' availability group actually is...can you explain further?

A listener is setup and configured to be used so that your applications can connect to...

Please outline the steps you took to add the database back into the AG?  Prior to doing that - did you actually remove the database from the AG or was...

Unless I am mistaken - Meditech is a vendor supplied and supported database.  Before upgrading the database system to 2016 - the vendor should have signed off on making that...

If you can provide the code for your function - I am positive someone here can modify the code to be language agnostic.  The code should not be affected by...

FIELDQUOTE looks like it was added in 2017, as well as the FORMAT = 'CSV' parameter.  This can be resolved using SSIS instead - since that will recognize the quotes...

Is the group an Exchange group - as in a DL - or an email group in AD?  If the DL is not defined with an email address it will...