Thanks,

But I found this seems more a certificate issue related with SQLdataclient version, see the link in the article

https://github.com/dotnet/SqlClient/issues/1836

Thank you , what is CVE?

And I also read this article https://www.sqltattoo.com/blog/2021/01/sql-server-patching-gdr-vs-cu/

Quote:

caution: When you start clean from a baseline you can apply GDR or CU as it fits...

Thanks, not sure what this means: Quote: "So it means its possible to use some security update, when you dont want use some CU due to some reasons."

We have something...

• This reply was modified 1 year, 11 months ago by  sqlfriend.

Thank you for asking that. I tried to reproduce the error, by creating the second log shipping database on the server, but I cannot...

Thank you.

For question 1 above, I have changed all my maintenance plan to OLA maintenance solutions.

I understand the backup folder structure just like what you described above, this is for...

Thanks,

1. Is it a good practice to put the transaction log backups for log shipping to a different folder  from other regular non-log shipping database  transaction logs backup folder?

2. do...

In this case, shall we remove all backups including full and differential...

In this case, shall we remove all backups including full and differential...

In this case, shall we remove all backups including full and differential...

For transaction log shipping, I still have questions:

we have a primary instance that has 4 databases on it, I only want to do a log shipping for 2 of them.

We...

Thanks,

If the witness server instance is also on location A, same location as ServerA the primary node, if a disaster happens,  will quorum still counts correctly?

Setup, administration and troubleshooting for AGs is much simpler than log shipping, especially on SQL2019.  The place I worked at last had a SQL cluster at each of two...

So again, how much pain do you want to be in when your up against it, and this will then drive the discussion about what technology and solution would...

• This reply was modified 2 years, 1 month ago by  sqlfriend.

Thank you for the article.

Can I ask: when you day: Enter port number 1433, and enter the IP address for your listener.  This should be an unused IP address on...

Mirroring is still available in 2019.

Log backup has to be done in sequence , if you want the log backup files for primary server recovery too, take the folder...