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...

It looks like the problem you are having is related to the fields being quoted.  You need to specify in the BULK INSERT statement that the file is a CSV...

In order for a database to be joined - it must have the latest transactions that have been backed up applied to the destination.  To shorten the number of transaction...