How to: Enable Initialization with a Backup for Transactional Publications (SQL Server Management Studio)
SQL Server 2005
To initialize a subscription to a transactional publication from a backup, enable the publication to allow initialization from a backup, and then specify backup information when creating the subscription:
Enable the publication on the Subscription Options page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).
Specify backup information with the stored procedure sp_addsubscription (Transact-SQL). For more information about the parameters required by sp_addsubscription, see How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming).
ConceptsInitializing a Transactional Subscription Without a Snapshot
Help and InformationGetting SQL Server 2005 Assistance