Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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.

share|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

Check out

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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