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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-07-07 : 12:27:42
|
| I've got a remote database that I occasionally copy to my hard rive using EM's Export utility.Anytime I need an update, I've been deleting the client copy and copying the entire enchilada.Is there a way I can synchronize the two and same some time and bandwidth?Sam |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-07 : 12:39:47
|
| Shortcut to the location and sp_attach maybe?How big is the db?Brett8-) |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-07 : 12:47:27
|
| 21 Mb. So you're thinking FTP it to the client?It's activly in production though..Sam |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-07 : 13:05:29
|
| Backup + zip?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Duplicating a database