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 |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2008-03-04 : 07:23:25
|
I have 2 sql server that are registered and linked. If I have a table in server 1 that I want to make a backup of to server 2, how would I do that in t-sqlv(if the table did not already exisit on the second server)Thanks"Impossible is Nothing"  |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-04 : 07:38:38
|
| Generate script of table from Server1 and execute it on Server2 and then you can use four-part naming convention to insert data from server1 to server2.If the data is too large, you can use DTS.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-04 : 07:44:43
|
quote:
Originally posted by harsh_athalye
Generate script of table from Server1 and execute it on Server2 and then add that server as linked server andyou can use four-part naming convention to insert data from server1 to server2.If the data is too large, you can use DTS.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
MadhivananFailing to plan is Planning to fail |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-04 : 07:47:15
|
| Madhivanan,OP said that those servers are already linked. Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-04 : 08:08:18
|
quote:
Originally posted by harsh_athalye
Madhivanan,OP said that those servers are already linked. Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
tsql help