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 2005 Forums
 Replication (2005)
 Replication

Author  Topic 

asm
Posting Yak Master

140 Posts

Posted - 2009-02-05 : 06:43:42
Hi,

Want to update the Head office Sql server database with remote location local database on weekly basis.
Pls guide which method of replication will be followed
and how the same will implement...

thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-05 : 22:30:08
Snapshot Replication or Transaction Replication.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-05 : 23:39:51
For a weekly process, I'd just use BACKUP/RESTORE rather than bothering with replication.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -