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

then create a DNS CNAME of name ServerA which points to the listener so then you don’t need to go change the applications either now or in a dr...

Regardless of whether you have an AOG listener, you can connect directly to either the primary or secondary using a connection string similar to that below. If connecting to...

Yes, thanks that is what I did, in SSMS I have to choose the full backup and differential,

then I generated the script, and comment out the full backup line, and...

I know mirroring is deprecated.

For...

Thank you.

I found out if I use SSMS to do that, it failed with error: full backup not selected even I use the right LSN differential or transaction log backup.

But...