Quick copy Db

[pomster]

I am looking for a quick way to copy a database on a regular basis from one server to another. I have Server1.db1 that I wish to copy and replace to Server2.db1

Any help appreciated.

cheers,

David

 

[hmckillop]

Depends on where these are located.
Have you tried looking at replication - this could be setup to run in one direction and send updates as and when they happen.
You then never need to copy the DB and replace.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[pomster]

The servers are on the same network, one is a production server, the other test. We also have a Dev server. What we do is copy the production database to test, rename the db then apply updates from Dev and try to break it. We don't necessarily want up to date data, just a snapshot.


cheers,

 

[hmckillop]

The only quick way I know of doing what you ask , is to use a compression backup tool to ensure the backup is as small as possible and then someone to copy the file over - you could setup a tool for doing this e.g. scheduled ftp etc, but depending on the frequency this might not make sense.

redgate SQL backup is a good tool and not expensive, there are others though.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[pomster]

thanks h, will look into it


cheers,

David

 

[markros]

Can you elaborate a bit about compression back up? Is it a standard option?

Thanks in advance.

 

[hmckillop]

Our company previously used litespeed for backups, but now we use redgate.

a traditional backup was around 135Gb and took about 1 - 1.5 hours, redgate now completes the task approx 15mins and backup size is 30Gb.

Have a look at

http://www.red-gate.com/products/sql_backup/index_v2.htm

"I'm living so far beyond my income that we may almost be said to be living apart

 

[markros]

Interestingly, I got a link to it today from MSSQLTips <newsletter@mssqltips.com>