Foreign keys can cause issues as dml can be delivered out of order, ie parent deleted before children. Make sure you have NOT FOR REPLICATION on fk constraints, we remove...

You could use wmi for that, ssis has a wmi transform

There is a feature called 'deferred update' in that an update to a column in a clustered index will replicate as a delete/insert pair.

Build an archive routine that moves rows...

To minimize the backlog, I take a full bak and start shipping it. When I have it restored, plus tran logs, then I add subscription. Take final tran log bak,...

TEst env right? so should be easier to isolate.. delete on pub, then fire merge agent while profiler running on subscriber.

Hth,

Chris

mssqlconsulting.com

File is 98gb, I presume the db file is not nearly as big, they don't manage log files, nor know how to point-in-time recover, or they wouldn't be reaching out....

I don't understand, datafiles grow in your dbData directory, log files grow in your dbLog dir, and backups grow in your dbBak dir. Additionally use the backup_size in backupset table...

What size is your datafile? If 400GB then 98Gb is ok. If not what recovery mode is db in? Full? Are you taking tran log backups? No? Only full baks...

Could be a few things. When is full bak taken? Immediately after index maintenance? Do you rebuild indexes nightly with a maint plan or under control, ie only rebuild the...

I like this one, run it once per week or month and log to a table. Can even go dim/fact tables and load into a cube, then create some nice...

Right-click db, properties, see Trans Log Shipping on left?? Follow wizards 🙂

Regards,

Chris

mssqlconsulting.com

We capture size a different way, however you can use backup_size in backupset, write to a dim/fact table and build a cube off of. Then drop in an excel pivot...

The only time you need to send your full to secondary is if you need a reinit. Otherwise take your fulls nightly and store locally, tran log baks will never...

Yes, no issues with replicating either merge or transactional between std vs ent.

My env Pub=Ent.Ed / Subs=Std merge & bi-directional-trans (diff tables)

Regards,

Chris

mssqlconsulting.com

Would be nice to have something more re-usable. I found this code with a google search, however is limited when drilling through Transaction Date dim, will not work when Year...