Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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 http://sqlbackupandftp.com/

share|improve this answer

Your Answer

 
discard

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.