Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aday
Starting Member
2 Posts |
 Posted - 2014-09-11 : 12:35:34
|
| Hey guys, I need to setup a weekly copy of specific databases between two servers.I am not sure what is the best way.snapshot replication or the copy database wizard?does anyone have some insight into this who can explain the differenceThanks, |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-09-11 : 16:23:39
|
With replication, you'll need to specify the objects that are sync'd. As your schema changes, you'll need to remember to modify your set of articles published. If you want to copy the entire database verbatim, have you considered doing a backup and restore to achieve your objective? You could create the necessary SQL Jobs to backup the database and restore it at the destination. I am assuming that there is some mechanism that the two servers can use to exchange or share the backup file.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
aday
Starting Member
2 Posts |
Posted - 2014-09-11 : 16:29:36
|
| I think that's what copy database wizard does as it is creating a dts package and running it as a scheduled job. |
|
|
|
|
|
|
replication vs copy database wizard