Yes - you can use the db backup as your snapshot.
1) You can use the gui to init, do NOT check the Initialize check box in New
Subscr. Wizard.
2) backup db
3) ship backup / restore. you have 48 hours to complete this before subscr
will expire.
An alternative here - perform full backup - ship - restore, tran log
backups, ship each over ftp - restore - add subscr - final tran log backup -
ship - restore.
4) run on publisher: exec sp_scriptpublicationcustomprocs @publication =
'PubName'
take output and exec on subscriber.
5) fire up distribution agent.
You may have a problem if your SQL2005 db is in 90 compatibility mode. You
may not be able to restore to SQL2000. Should test.
Viel glueck!
ChrisB MCDBA
MSSQLConsulting.com
[quoted text, click to view] "PhilD" wrote:
> I have replication running from SQL2005 to SQL2000, The amount of data has
> grown so large that when a new snapshot is generated it takes a very long
> time to send to the subscriber. I am using push transactional replication.
> The distributor and publisher are on the same server in Germany and the
> subscriber is in San Francisco. I would like to generate the snapshot on the
> German server and send it on DVD to the subscriber. I have created it on the
> German server in a folder and compressed it so I know it should be small
> enough to fit a DVD. Is there a way to do this using the current set up?
Also have a look at the option @alt_snapshot_folder of
sp_addpullsubscription_agent. It allows you to specify a location on the
subscriber to restore the snapshot files from. Generate the snapshot on the
publisher, copy them to the subscriber (possibly on a dvd) and then point to
the location of the dvd in this parameter. Note you have to provide the
entire repldata directory structure for your snapshot.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "PhilD" <PhilD@discussions.microsoft.com> wrote in message
news:C62DFEB5-EB92-4A0C-B963-C0713BA7B5E5@microsoft.com...
>I have replication running from SQL2005 to SQL2000, The amount of data has
> grown so large that when a new snapshot is generated it takes a very long
> time to send to the subscriber. I am using push transactional replication.
> The distributor and publisher are on the same server in Germany and the
> subscriber is in San Francisco. I would like to generate the snapshot on
> the
> German server and send it on DVD to the subscriber. I have created it on
> the
> German server in a folder and compressed it so I know it should be small
> enough to fit a DVD. Is there a way to do this using the current set up?
> Any assistance would be appreciated
