Database migration

[mkal]

I have a couple rather large databases 36-40gb and some smaller databases 250mb - 6gb that need to be migrated from our existing server to a site that will be hosting our databases for us. We had thought to use log shipping to migrate the data as we need to keep the databases in sync till we can cut over with out interrupting our web services that use the databases on our end. One of our issues is pushing the data through the VPN between us and the hosting service - the problem being the initial backup and restore errors out or times out. Anybody else ever run into this problem and what did you do to solve it.

Best Regards

 

[ptheriault]

You may want to look into a tool like lite speed by quest. It will give you @85% compression on your backups. You can also use it for Log shipping.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mkal]

Would transactional replication be an alternative to logshipping? I don't have and am not likely to get a version of litespeed?

Thanks

 

[ptheriault]

it would be an alternative but you still have to either let the snap shot agaent script out, copy and create the database or restore an initial database backup on the source.

- Paul

- If at first you don't succeed, find out if the loser gets anything.