I want to replicate a data of 500 GB through transactional replication once in a day, so my query is this, will it create a new file in the snapshot folder on daily basis of 200-300 GB or will update it only.

What can I do if i don't have too much memory for this file, can we not transfer our data without generating this file.

  • Is this 500GB in a subset of tables in a larger database, or is your database 500GB in size? – John Eisbrener Aug 23 at 13:27
  • I don't think it's good idea to use snapshot replication for this large database. So I'd suggest to use log-shipping with stand-by secondary if you want to use secondary for read-only purpose. – Rajesh Ranjan Aug 26 at 12:14

The SQL Server Snapshot Agent will use BCP to create an initial snapshot of the data and objects to be replicated.

These are stored on disk in the default installation folder. You can specify a different location if you are concerned about space issues in the default location.

Once the snapshot has been distributed to the subscribers, subsequent changes will be stored in the distribution database and sent to the subscriber at the frequency you choose.

If you don't need to create and send a snapshot every day you might save time and bandwidth only sending the differences for a while before refreshing the snapshot.


If you're basically only making a copy of the database once-per-day, Log Shipping may be less headache to deal with, or you can roll your own solution and just automate daily backup/copy/restores to a secondary database instead - john-eisbrener.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.