Hi just about the situation I mentioned before - to record the last record in a table?

I setup a demo test DB for replication and followed the instructions and was ok.

If I have multiple subscribers do I need to run this command per subscriber?

Hi,

My plan so far was

Drop article from replication
Rename table to table_tmp
I assume I need to rename this table on the subscribers as well
Create...

Cool, what are your thoughts on using the AWS Migration service instead of native SQL to produce SQL replicas ? If you are lacking on SQL experience it makes it...

Hi,

Thanks I think I know what has happened today.

We have a production Sage ERP DB and two subscribers to the DB. All good.
Someone rang a...

Hi,

That's ok then.

So I need to do a full backup

Then a log backup

And restore both in that order?

s.

Will it be easier to switch the mode to Simple before the migration?

Hi,

Actually I'm probably just going to do a Full DB backup with everyone out - will that be enough or does it need a log backup?

Hi,

The recovery mode is Full.

During the maintenance window I will restrict access to just me so the diff backup will be correct?

Hi thanks for the response.

Do I create the DB on the new subscriber with just the tables I want to replicate or a full DB backup and restore?