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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Moving Snapshot from Distributor to Subscriber...

Author  Topic 

jonathans
Starting Member

40 Posts

Posted - 2007-08-22 : 05:14:41
Hi all

Can the Snapshot be copied from the distributor to the subscriber and then from the subscriber using the copied snapshot, create a subscription to the publisher?

Urgent help would be greatly appreciated

WARNING: Running on cold coffee!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-22 : 15:26:49
You can script it, modify the script and apply it on the machine.
Go to Top of Page

jonathans
Starting Member

40 Posts

Posted - 2007-08-23 : 03:18:38
Which script? The publishers script?

And by modifing the script, surely it will recreate the snapshot? That is the experiance i had yesterday.

Thanks for the tip though, will look into the script side a bit more

WARNING: Running on cold coffee!
Go to Top of Page

jonathans
Starting Member

40 Posts

Posted - 2007-08-23 : 03:24:39
Which script? The publishers script?

And by modifing the script, surely it will recreate the snapshot? That is the experiance i had yesterday.

Thanks for the tip though, will look into the script side a bit more

WARNING: Running on cold coffee!
Go to Top of Page
   

- Advertisement -