Thank you Anthony.

This built in function would require ('DBName') as well.

Since I have all the databases  as part of AG, would it safe to assume that providing just  one DBName...

Here's my scenario:

I have only one Full backup job running on Primary Node.

When the Node fails to Secondary, backup job does nothing, but as suggested if I add "copy_only" parameter...

Backup Preference "Prefer Secondary" is selected.

But ,for T-log I am able to run in any node adding this parameter ""@OverrideBackupPreference='Y' ".

Thanks.

10-1-2019 thru 10-4-2019

Thanks.

Tried performing the recommended but still failed.

Seeing this error message on the sql agent log :

SQL Server does not accept the connection (error: 18456). Waiting for Sql Server to allow...

Subsystem is using Operating System, have enabled xp_cmdshell

using this command in sql agent:

copy /y \\sourceserver\E$\test\*.txt f:\test\*.*

Agent is local admin to both servers, but have  not specifically provided security to particular...

• This reply was modified 5 years, 1 month ago by  PJ_SQL.

We are using Service Accts but looks like somebody tried to change the account or password.

SQlagent.out file has the error message "Login failed for user". So I am trying to...

Thanks Sue for the information.

So, basically SQL Instance  would need to hardcoded in the application for read-only purpose.

In this scenario how would failover work?

Node 1 : all connections

Node1 : readable...

Other thing is I was able to delete those files which were not showing on GUI but when I run the scripts those file name still show up.

Maybe failing it...

Microsoft SQL Server Management Studio      14.0.17289.0

Microsoft Analysis Services Client Tools      14.0.1016.283

Microsoft Data Access Components (MDAC)      10.0.17134.1

Microsoft MSXML      3.0 5.0 6.0

Microsoft Internet Explorer      9.11.17134.0

Microsoft .NET Framework      4.0.30319.42000

Operating System      6.3.17134

When looking into the properties of TempDB on SSMS, I  just see two files not all the files that the script provides.

Thank you Andreas.

So,different version of SQL Server would not hinder log-shipping from 2012 to 2016?

Also, could you also mention the steps to bring the secondary Database online?

Thank you.

• This reply was modified 5 years, 7 months ago by  PJ_SQL.

Thank you for the explanation.

We do have couple of jobs that run during that timeframe other than maintenance jobs, it could be because of that.
It is not causing any issues but wanted to...

I agree with Beatrix. I was able to restore using T-SQL instead trying from GUI>