Backup SqlServer to a FTP-folder

Question

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?

DanBig · Accepted Answer · 2011-04-29T12:47:58.097

3

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.

edited Apr 29 '11 at 12:47

answered Apr 29 '11 at 12:27

DanBig

11,423
1
29
53

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

score 2 · Answer 2 · answered Apr 29 '11 at 12:48

2

Check out http://sqlbackupandftp.com/

answered Apr 29 '11 at 12:48

sgmoore

652
5
10

Backup SqlServer to a FTP-folder

2 Answers2