You may consider replications (transaction for large database and snapshot for small database). However, transactional replication is harder to maintain.
You may also consider the differential backup/recovery.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply