up vote 0 down vote favorite
share [g+] share [fb]

Is it possible to let SQL Server 2008 make a backup to a FTP-folder.

I know it's possible to specify as the backup target in SSMS an UNC-path. But is there also the possibility to specify an FTP-Folder (inclusive user name an pwd)? If yes, what is the syntax?

link|improve this question
feedback

2 Answers

up vote 3 down vote accepted

You will probably need to write an app in conjunction with a T-SQL script to do this, as there is nothing native to SQL server to backup to FTP.

EDIT: Something like this.

link|improve this answer
An app or only a TSQL-Script? Is it possible with TSQL? – HCL Apr 29 '11 at 12:40
Most likely a combination of both. – DanBig Apr 29 '11 at 12:47
feedback
up vote 2 down vote

Check out http://sqlbackupandftp.com/

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.