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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-27 : 07:59:11
|
| DesperateWithReplication writes "I created a transactional replication in SQL2000.I decided not to create a snapshot of the schema and data because the database in very big. So I restored a backup of the db in the subscriber.After creating the publication and then the subscriber with a push subscription I schedulled the subscription.I get the following message as result: cannot find sp_MSupd_<Table_Name>.Where is this sp created? How can I work this around?thanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-27 : 07:58:59
|
From Books Online:quote:
Transactional ReplicationWith transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers.
Restoring a backup won't accomplish the same thing. |
 |
|
|
|
|
|
Replication error