SQL 2008 update

  • We use SQL 2008 Express to customers sites. We need to maintain a backup to our portal. We first take a full backup from each customer site and then restore it to our portal. Then, on a regular basis, we need to restore to our portal only the changes made to customers dbs. So, we need to take the changes made after full backup or after the last restore and 'play' them to our portal db. The customers do not have internet connections, they run on Vessels, so the backup file should be as small as possible. Differential file is not small.

    Are there any other options ?

  • This sounds like an application for log shipping.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply