SQL Backup Script against Software
Comments: 0
SQL backup scripts seem to be intended for those interested in feeling safe about their data. But, at least once, these users definitely have come across modern backup & restore software market. Nowadays, this niche has to compete for users’ attention with the growing amount of the free SQL backup scripts on-line. Let’s try to find out why should anyone reject the proprietary solutions for the professional data reserving.
Version 7.4.0, built on June 17, 2013. 22.5 MB, 32-bit (above) or 28.7 MB, 64-bit version
Backup Software from Novosoft LLC. 99 USD per license.
Download Home Professional and see how the SQL backup script below stands against the specialized software!
SQL Script Example: What and Why
The cross-platforming problems does contribute to the situation. The common situation is something boasts smooth performance under Windows, but experiences hard times being run under Linux (if does work at all). This is the way people start to run SQL scripts.
The lack of trust for proprietary software (as a product type) from the user community can also be regarded as a reason. SQL backup script users tend to think the companies are only interested in making as much money as they can, without paying attention for the what the users really need. While this is true for some, it’s definitely not for the others (in fact, giving users what they really need IS the best way to make money).
Running SQL Scripts vs Using software
Even with all the reasons above, the proprietary software does deserve its’ niche in our lives, and the current one has to be expanded greatly. It seems unlikely for anybody, who has tried the professional-developed software, to come back to the running SQL scripts. However, today the non-free solutions definitely are not getting the credit, they deserve.
The situation NEEDS to be changed, and Handy Backup is accepting the challenge. Right now we are going to show you that our product easily does everything the popular scripts do, but our solutions are far smarter. Fell free to download one of the famous on-line SQL script examples as well as the newest Handy Backup below. So, you get a chance to compare both approaches and choose the one which suits you the best.
Version 7.4.0, built on June 17, 2013
22.5 MB, 32-bit (above) or 28.7 MB, 64-bit version
The source code is right here: download SQL Server Backup Script
Note: this script was not tested by Novosoft. Please understand the risks as you decide to use it.
What the SQL Server Backup Script does: this one loops through all the databases dynamically using a select statement to the master database where all the names of the databases are located on the instance. It backs up each database, except those specified in the WHERE clause which you can add your unwanted databases to be backed up.
Script author: OverDrive, Administrator at Mitutoyo Canada.