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 |
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-11-11 : 11:48:40
|
I have the same database on 2 different servers which are connected.I want to import and refresh from server A to B. At the last point, it says it will APPEND the data, I would like just a refresh. What does it mean by APPEND, that it will add the rows? Or refresh. |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-11 : 11:52:23
|
Append means always: keep old data and append the incoming data.I would do that with backup and restore (with copy_only). No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|