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 |
|
pecka
Starting Member
1 Post |
 Posted - 2006-03-01 : 06:16:23
|
| Hi!We have a system with one central database server with 10 clients.During normal operation all the clients use the central database.But now the customer also wants to be able to run from the local database on the client.But before doing that, all the data in the central database needs to be copied into the local client database.This has been done before by using a DTS package. The problem here is that the customer changes password each month, and then you need to manually edit the DTS package to get access.What I want to do is a procedure that runs on the local database that connects to the central database, triggers a backup, and when finished restores the local database with the new backup.Can this be done?Any input would be appreciated. |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-03-01 : 08:22:55
|
| Have you looked into replication? |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-01 : 08:23:27
|
| Use Snapshot Replication - Refer Books On Line |
|
|
|
|
|
|
Backup remote db, restore on local.