SQLBackupAndFTP (a product review)


After reading Pinal Dave blog post on Best Practices to Store the SQL Server Backups, I noticed he mentioned an “easy to use” SQL Backup 3rd party software that allows network storage, even FTP transporting.

So, I thought I would give SQLBackupAndFTP a try.  The download is a relatively small foot-print and installation was a breeze, however I wish there were a x64 bit version.  I know x64 bit machines will run the software, but it is my personal “best practices” to not use x32 bit software with x64 bit machines.

Dave was right, this is most definitely an “easy to use” software.  I can see it coming in real handy with applications that require SQL Express.  With the database sizes (almost 1TB of data on one server) I work with, remote storage and FTP are not a viable option.  Setting up the network storage was a breeze.

I was a little worried when the error message popped up concerning Remote SQL Server backups, especially since it mentioned “beta”.

I believe this would be an excellent development/test environment backup solution because it can be installed on the server and managed on each server.  However, in a production environment with over 90 SQL Servers, a remote backup solution  would be ideal.  I am afraid this would not be the solution.  I could be wrong.  I am a little fearful to place it into production right now.

However, that all being said, I will definitely be putting it to use on my development servers, workstations and test servers.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s