How to copy a subscription database (Enterprise Manager)

1. On the Subscriber, in SQL Server Enterprise Manager, expand the Replication and Subscriptions directories, right-click the pull subscription that has a subscription database you want to copy, and then click Copy Subscription Database.
   
   
2. In the Copy Subscription Database dialog box, browse to the directory or drive where you want to save a copy of the subscription database.
   
   
3. The location can be on the network, using removable media (such as CD-ROMs or tape devices) or on a File Transfer Protocol (FTP) site.
   
   
4. In the File Name box, type a name for the subscription database file (the file will have the extension .msf).