Hello folks! A colleague asked me a very interesting question. Currently a friend of his works for a company with SQL Server 2000 transactional replication. They have the source database at Head Office, and it replicates to 10 child servers. They want to upgrade to SQL Server 2005. What they intend to do is backup the database, install 2005, and then restore the backup. They'll then be running some upgrade scripts. My question is as follows: When they set up the new replication on SQL Server 2005, will they have to redo the snapshot, etc.? Or is there a way they can just continue from where they left off, i.e. replicate just changed / added records to the child servers. The problem is they only have 256k line, and to have to do a snapshot again of a 29GB database to the child servers will take forever! Thank you in advance for any assistance in this regard.