SQL Backup tool - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Backup tool

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-10-22 : 10:40:04

We are planning to take a thirdparty backup tool, which does compression, encryption and copying bakup file to a offline location using ftp(for diaster recovery)

Please let me know whethere any tool is there that supports ftp.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-22 : 13:21:50

I don't know that any of them support ftp. What I'd recommend is that you backup locally and then have a script run that does the ftp for you to another location.

What version of SQL Server are you using? 2008 with Enterprise Edition has native compression.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-10-22 : 13:32:11

Thank you for your reply. Can you provide script that does ftp, do i need to manually run script everytime?

SQL Server 2005

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-22 : 13:36:01

I don't have a script handy as I don't use ftp. I'd google search it if I were you. You don't need to know how to ftp a SQL Server file but rather all you care about it ftp'ing a file (any type of file).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources