I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2.

Script replication environment.

Run commands to flush distribution database
Backup distribution DB
Remove SQL Server 2005
Install SQL Server 2008 R2
Service Pack SQL Server
Assign Permissions to Snapshot Directory
Check PAL permissions
Recreate replication Publications
Recreate replication agents
Recreate replication subscriptions

reapply indexes to the subscribers? (if a new snapshot is applied)
reapply maintenance jobs

if the snapshot directory remains the same with snapshots taken in 2005, will a new install of SQL 2008r2 use these snapshots or will it generate a new snapshot ?
(not a massive issue at 3am, but just for my estimated timings)

Do I need to remove the distribution ServerName from sys.servers on the Publisher Server ? is anything left in the system tables that I should clear out manually ?

I wanted to change the security to be windows based security as its currently running under 'sa' login. (obviously not good). But have had issues getting this to function after changing the initial config, so thought it might be useful to do it at initial reinstall and switch to 'sa' if unsuccessful.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.