Copying a Subscription Database
After you have configured the subscription options in the publication, created, and synchronized a pull subscription to a subscription database, you can copy the subscription database.
The copy of the subscription database includes data, views, stored procedures, user-defined functions, schema, and all objects that are not replicated that comprise the database. Only subscription databases that are contained in one, primary file group can be copied. You must synchronize at least one subscription to the subscription database before copying.
During the copy process, a compressed Microsoft Subscription File (.msf) is created. The .msf file contains subscription information up to the last synchronization of the subscription database.
When creating the .msf file, save the file to a location. The file can then be picked up and transferred over the network, transferred using removable media, or attached to an e-mail message.
To copy a subscription database