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
 SQL Server Administration (2008)
 Refresh DB simple problem

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

- Advertisement -