• Here is a sample script

    •Modify and execute the sql below on the publisher to create the subscription

    exec sp_addsubscription @publication = N'<publication name', @subscriber = N'<instance>', @destination_db = N'<destination database>', @sync_type = N'initialize with backup', @backupdevicetype = 'disk', @backupdevicename = 'd:\rep.bak', @subscription_type = N'push', @update_mode = N'read only'

    GO