Thank you !!

Hi Jeffrey,

thank you for your response.

I tried with your suggestion but it gives different error below.

script:

$dt=get-date -format "_yyyymmmd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM XXXXXXX" -ServerInstance "LocalHost"

$fileName = "D:\folder\data$(dt).csv" |

Export-Csv -Path $fileName...

Hi,

I tried with below script through sql job and its failing with below error.

script:

$dt=get-date -format "_yyyyMMMdd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM [XXXXX].[XXX].[XXX]" -ServerInstance "LocalHost" |

Export-Csv -Path D:\folder\data$dt.csv" -NoTypeInformation

Error Message:

Executed as user:...

Sorry I was busy with prod issue after this post .i will check your suggestions tomorrow and reply.

Thank you for your suggestions.

Thank you !!

so we will need to update the latest Cumulative updates(CU7)  for sql2016 ?

yes the firewall is already enabled  and we are able to connect to other sqlservers\instances .

Thank you to both of you.
My problem solved .

we have multiple databases.
the secondary server is only for DR purpose.
can we use the same key for secondary installation?

master key and certificate will be removed by uninstalling the SQL server ?

Hi,
I have one more requirement.
Planning to migrate the database from sql2008 standard to sql2016 enterprise.
But...