Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ynaina
Starting Member
9 Posts |
 Posted - 2011-10-02 : 03:15:44
|
| I have two transactional replication and one snapshot replication in my server(Publisher) SQL 2005. I am doing a migration to SQL 2008. Is there a way to take backup and restore the replication in SQL 2008. Current Setup=============Data in SQL 2005 ---> Replicating to --> SQL 2005After Migration===============Data in SQL 2008 ---> Replicating to --> SQL 2005 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-09 : 11:13:29
|
| No. You should script it out and apply the scripts on new servers. |
 |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-11 : 12:36:05
|
| You can script and migrate to the other databse as mentioned above ,also you can follow the MSDN tips from the Microsft site.Sr Sql server DBA/Artitech |
|
|
|
|
|
|
Backup & Restore Replication