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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2006-10-09 : 12:41:03
|
| Hello,I am doing the restore of Database from production server to Test server. I wanted to automate this process of restore.I wanted a script which can SFTP (SSH Transfer) , from the test server to the prodcution server. So, that the script can go over to the prod and get the required files.Now what I am doing is , getting the back up copy from the production server to the local machine and then refreshing/restoring on the test server.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-10-09 : 13:07:43
|
| Hello NR,Thanks for the scripts. I was looking for the script of:FTP get file using tsql. I have got the scripts for the backup and restore of the DB's. But I didnot know how to get the Backup files from the Prod sever to the Test server using the SFTP .Thanks |
 |
|
|
|
|
|
Help - Script of SFTP from One Server to Anothe