I think your plan should work. That's basically what we did a few months ago.

But records at the publisher might change after the backup is taken but before the db is restored and replication is set up .... or am I missing something here...

I might be able to help with the SQL script if I had more details of what you actually want to do. I'm not the person to ask about VB....

Hmmmm    I suppose you could have a stored procedure that does the update, then VB script or something to execute the stored proc

I think you'll find the buttons up on the top of the EM bar, not in their old Win2000 location. It threw me for a little while.

Just wait 'till you try them in SQL 2005, they're even worse !

Just to add a simplified version ..........  When there are updates & writes, SQL logs that information in the transaction log. If you never backup the TLog, then SQL says...

ALTER DATABASE    MY_DB    COLLATE    SQL_Latin1_General_CP1_CI_AS

You mean the schedule area of the Maint plan is blank ?

In a maintenance plan, you have tabs for different options: Optimization, Integrity, Complete Backup and Transaction Log Backup. Each...

Transition to SQL2000 from what ?   And why is this in the "SQL Backup" forum ?

A little detail would be helpful .....         My car won't start, what's wrong with it ?

Here are my notes from when I encountered this. Perhaps you had the same problem as me in step 1 because the restored database was not a publisher ?

1)...

Another way is to script out the "drop publication" and "create publication" commands, then run just the ones to drop your specific articles.

This comes in handy if you need to...

Maybe your subscriptions are expiring. You can change that in the publication by selecting "Subscriptions never expire"

How big is the table ?  If it's small, maybe it would be easier to DTS the AS/400 table every night into your SQL table and replace the data. I...