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 |
|
e32o
Starting Member
1 Post |
 Posted - 2003-01-08 : 14:06:12
|
| Anyway i can get SQL 2000 to backup and db, then ftp that file over a network to another server. I know i can map the drive and backup to the network, but the server it's going to is a linux server and these 2 servers can't see each other on the network. Thank you in advance for any help.[e] |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-08 : 14:24:29
|
| Well you could do this through DTS because DTS has an FTP task or you could do it through xp_cmdshell and call a batch file that has the appropriate FTP commands. So you would backup the database to say C:\Bkp\DB.bak and then FTP this file to the FTP server. Whatever you would type in at the command line can be put in a batch file and then called from xp_cmdshell.Here is an example:BACKUP DATABASE DB TO DISK = 'C:\BKP\DB.bak'WITH INITxp_cmdshell 'C:\ftpjob.cmd'The only part left to do is to put the FTP commands in ftpjob.cmd. You could then save the above script and schedule the script to run.Edited by - tduggan on 01/08/2003 14:27:13 |
 |
|
|
|
|
|
Backup DB and have SQL FTP it over to another serv