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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-13 : 07:49:37
|
| Tiamiyu writes "Okay!I have four servers that I am trying to update periodically. One of them is a processing server and the other three are production servers. They all have thesame copy of the processing server.What I want to is to be able to periodically copy the database on the processing server to the remaining three servers.What I am hoping to do is as follow:1. detach the database on the processing server2. ftp the data and log files from processing to all the three servers3. Attach the database back on processing server4. From the processing server, detach each of the servers and attach them with the new files.I know that 1 through 3 are possible but I am not sure if 4 is possible.Anybody with any idea on this will be highly appreciated. Or if you have a better idea for me, that will be great!ThanksTiamiyu" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-13 : 08:54:29
|
| Yes it's possible if you have permission and a connection.You are controlling each of the remote servers from the processing server.Why not create a job on each of the remote servers to do it - the job could run at a certain time and look for the appearence of the files (rename or move them to the directory after the ftp or you will get locking problems).You could also use sql-dmo to copy all the objects instead of a dettach/attachseewww.nigelrivett.comDMO transfer==========================================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. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-13 : 12:21:06
|
| Duplicate post:[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=24466[/url]We already provided a better solution for you in the above thread. What more do you want?Tara |
|
|
|
|
|
|
Detaching databases remotely