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.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 replication vs copy database wizard

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 difference

Thanks,



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
Go to Top of Page

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.



Go to Top of Page
   

- Advertisement -