You could use transactional replication, or any type you decide.

Then create a batch command that executes the jobs of the distribution agent. You can use osql -Q"exec msdb.dbo.sp_start_job..." inside a...

If you are going to execute the query more than once, or frecuently, you shoud use a linked server.

But for one time execution, it is the same.

Copying the files will also take a long time if they are really big.

Also keep in mind that with a restore you also check that the backups are executing right....

Also check that in the job, in the Advanced tab, you don't have 'Quit the job reporting failure' on the success action.

A bit more complicated at the beginning but faster in the end, would be to use the bcp command to export, and bulk insert to import.

In my test I have...

Diferential backups, take the changes since the last full backup. Once you made a diff backup,

all the other differential backups you made, are useless.

You should backup the full backup...

If you restore, you will hold the history information of your jobs. And in the future you plan to use Master/Target Servers to centralize your jobs, or also use replication,...

Where you running a log backup while trying to shrink the file?

The only way is to delete the sp sp_dropsubscription on the publisher in the published db.

So, you coud execute the sp remotely from the subscribers, if you have the publisher...

If you are using stored procedures to replicate the changes, you can alter those prodecures, to delete the data you want when the distrib agent runs.

What errors are you getting ?

You can also set transactional replication in both ways with loopback_detection ON.

With this all the transacctions from the primary will travel the the backup, what it wont return from the...

Also think that transactional would be the best. You will only have to create a snapshot one time, and also with transactional replication, you can configure the snapshot agent not...

hi folks, I check the SP3 log file, and found some errors, so the last operator that installed the sp3 on those server, failed in some point, and he didn't...

I Know. But when I decided to continue with sp3 I didn't find any fix to bcp.