asked
How to take backup of sql server db and push it to remote ftp site
Hello everyone, I want to know is this possible to take backup of sql server database directly on remote ftp site through sql server management plan??? if yes than can somebody provide me script/guidance regarding this or else I need to do it through program.
[SSIS Script task that FTP's files][1] [1]:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2b7cf6b5-d16d-44cd-954d-68e9ba98ee91
following script is very usefull for my requirement...Although its not so efficient but still, does my work. BACKUP DATABASE [testdb] TO DISK = N'D:\Backup\testdb.bak' WITH INIT , NOUNLOAD , NAME = N'testdb backup', NOSKIP , STATS = 10, NOFORMAT EXEC master.dbo.xp_cmdshell 'ECHO open localhost> D:\Backup\FTP.TXT' EXEC master.dbo.xp_cmdshell 'ECHO share>> D:\Backup\FTP.TXT' EXEC master.dbo.xp_cmdshell 'ECHO share@123>> D:\Backup\FTP.TXT' EXEC master.dbo.xp_cmdshell 'ECHO put D:\Backup\testdb.bak>> D:\Backup\FTP.TXT' EXEC master.dbo.xp_cmdshell 'ECHO quit>> D:\Backup\FTP.TXT' EXEC master.dbo.xp_cmdshell 'ftp -s:D:\Backup\FTP.TXT'
Try SQL Backup Master. Can publish SQL Server database backups not only to FTP, but SFTP/FTPS, Dropbox, Amazon S3, and more.
http://www.sqlbackupmaster.com/
If you do not want use any third party software, then you can create a SSIS package to handle this task. You can use the Backup Database Task or SQL Script Task to invoke the BACUP DATABASE. Then simply connect this task using precedence constraint to a FTP Task, which will take care about transfer to remote FTP site. This is much more secure than allowing xp_cmdschell and you do not need any third party components or tools.
I'm using SQLBackupAndFTP [
http://sqlbackupandftp.com/][1] for such purpose. [1]:
http://sqlbackupandftp.com/
3 People are following this question.
