{"id":243,"date":"2013-02-28T22:11:44","date_gmt":"2013-03-01T03:11:44","guid":{"rendered":"http:\/\/sqlbackupfree.com\/?p=243"},"modified":"2013-02-28T22:11:44","modified_gmt":"2013-03-01T03:11:44","slug":"best-sql-backup-software","status":"publish","type":"post","link":"https:\/\/sqlbackupfree.com\/best-sql-backup-software\/","title":{"rendered":"Best SQL backup software"},"content":{"rendered":"<p>If you have a SQL Server database, you have to make the backups. Let me tell you about the simplest software on earth to make the SQL backups &#8211; it is\u00a0<a href=\"http:\/\/sqlbackupandftp.com\/\">SQLBackupAndFTP<\/a>. \u00a0Download a free version, 1 minute configuration and your daily backups are safe in the cloud.<\/p>\n<h2>What\u00a0SQL Backup And FTP does<\/h2>\n<p>In summary, the software<\/p>\n<ul>\n<li dir=\"ltr\">Creates SQL Server database backups (Full, Diff, Tran log) on any schedule<\/li>\n<li dir=\"ltr\">Compresses and encrypts the backups<\/li>\n<li dir=\"ltr\">Sends backups to a local, network folder, HDD drive, FTP Server, Dropbox, Google Drive, \u00a0Amazon S3, Box, SkyDrive. (We wrote before about\u00a0<a href=\"http:\/\/sqlbackupfree.com\/sql-server-best-places-to-store-backups\/\">Best places to store SQL Server backups<\/a>)<\/li>\n<li dir=\"ltr\">Sends email confirmation on job success or failure<\/li>\n<\/ul>\n<p>See full list of <a href=\"http:\/\/sqlbackupandftp.com\/features\/\">features<\/a><\/p>\n<p>SQLBackupAndFTP\u00a0comes in Free and Paid versions (starting from $29) &#8211; see\u00a0<a href=\"http:\/\/sqlbackupandftp.com\/features\/\">version comparison<\/a>. Free version is fully functional for unlimited ad hoc backups or for scheduled backups of up to two databases &#8211; it will be sufficient for many small customers.<\/p>\n<h2>Main backup form &#8211; it is all you need<\/h2>\n<p>From the beginning I was impressed that it was\u00a0immediately\u00a0clear how the program works and I was able to configure a backup job from a single form under a minute. Here&#8217;s the steps you should follow:<\/p>\n<ol>\n<li dir=\"ltr\">Connect to you SQL server and select databases to be backed up<\/li>\n<li dir=\"ltr\">Click \u201cAdd backup destination\u201d to configure where backups should go to (\u00a0local, network folder, \u00a0HDD drive, FTP Server, Dropbox, Google Drive, \u00a0\u00a0Amazon S3, Box, SkyDrive). Read more about\u00a0<a href=\"http:\/\/sqlbackupfree.com\/sql-server-best-places-to-store-backups\/\">Best places to store SQL Server backups<\/a><\/li>\n<li dir=\"ltr\">Enter your email to receive email confirmations\u00a0on job success or failure<\/li>\n<li dir=\"ltr\">Set the time to start daily full backups (or go to Settings if you need Differential or \u00a0Transaction Log backups on a flexible schedule)<\/li>\n<li dir=\"ltr\">Press \u201cRun Now\u201d button to test<\/li>\n<\/ol>\n<p>A\u00a0<a href=\"http:\/\/sqlbackupandftp.com\/tutorial\/\">detailed tutorial<\/a>\u00a0is available on developers website.<\/p>\n<p><a href=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/main.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31\" alt=\"main\" src=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/main.png\" width=\"636\" height=\"635\" srcset=\"https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/main.png 636w, https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/main-150x150.png 150w, https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/main-300x300.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<h2>Where to store the backups<\/h2>\n<p>When you click &#8220;Add backup destination&#8221; on the main form, you are given these options &#8211; I would advise you to keep it somewhere on the network and on the cloud (more about\u00a0<a href=\"http:\/\/sqlbackupfree.com\/sql-server-best-places-to-store-backups\/\">SQL Server backups &#8211; cloud storage options<\/a>)<\/p>\n<p><a href=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/destinations.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-168\" alt=\"destinations\" src=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/destinations.png\" width=\"256\" height=\"289\" \/><\/a><\/p>\n<h2>Advanced Backup Schedule<\/h2>\n<p>You can get to this form if you click \u201cSettings\u201d buttons in the \u201cSchedule section\u201d. Select what types of backups and how often you want to run them and you will see the scheduled backups in the \u201cEstimated backup plan\u201d list<\/p>\n<p><a href=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/advBackup.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-247\" alt=\"Schedule\" src=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/advBackup.png\" width=\"442\" height=\"372\" srcset=\"https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/advBackup.png 442w, https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/advBackup-300x252.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/a><\/p>\n<h2 dir=\"ltr\">One-Click SQL Restore<\/h2>\n<p>Along with SQLBackupAndFTP setup gives you the option to install \u201cOne-Click SQL Restore\u201d (you can install it stand-alone too) &#8211; a basic tool for restoring just Full backups.<\/p>\n<p><a href=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/sqlrestore.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-248\" alt=\"sql restore\" src=\"http:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/sqlrestore.png\" width=\"461\" height=\"357\" srcset=\"https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/sqlrestore.png 461w, https:\/\/sqlbackupfree.com\/wp-content\/uploads\/2013\/02\/sqlrestore-300x232.png 300w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/a><\/p>\n<p dir=\"ltr\">However basic, you can drag-and-drop on it the zip file created by SQLBackupAndFTP, it unzips the BAK file if necessary, connects to the SQL server on the start, selects the right database, it is smart enough to restart the server to drop open connections if necessary &#8211; very handy for developers who need to restore databases often.<\/p>\n<h2 dir=\"ltr\">SQLBackupAndFTP vs\u00a0Back Up Database Task (Maintenance Plan)<\/h2>\n<p dir=\"ltr\">You may ask why is SQLBackupAndFTP\u00a0\u00a0better than maintenance tasks available in SQL Server? While maintenance tasks are relatively easy to set up, SQLBackupAndFTP is even easier and integrates solution for compression, encryption, FTP, cloud storage and email which make it superior to maintenance tasks in every aspect.<\/p>\n<p dir=\"ltr\">On a flip side SQLBackupAndFTP is not the fanciest tool to manage backups or check their health. It only works reliably on local SQL Server instances. In other words it has to be installed on the SQL server itself. For remote servers it uses scripting which is less reliable. This limitations is actually inherent in SQL server itself as BACKUP DATABASE command \u00a0creates backup not on the client, but on the server itself.<\/p>\n<p dir=\"ltr\">This tool is compatible with almost all the known SQL Server versions. It works with SQL Server 2005,\u00a0SQL Server 2008, SQL Server\u00a02012 and many of the previous versions. It is especially useful for SQL Server Express 2005 and SQL Server Express 2008, as they lack built in tools for backup.<\/p>\n<p dir=\"ltr\">I strongly recommend this tool to all the DBAs. They must absolutely try it as it is free and does exactly what it promises. You can <a href=\"http:\/\/sqlbackupandftp.com\/download\/\">download your free copy<\/a> of the tool from here.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have a SQL Server database, you have to make the backups. Let me tell you about the simplest software on earth to make the SQL backups &#8211; it is\u00a0SQLBackupAndFTP. \u00a0Download a free version, 1 minute configuration and your daily backups are safe in the cloud. What\u00a0SQL Backup And FTP does In summary, the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"_links":{"self":[{"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/posts\/243"}],"collection":[{"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/comments?post=243"}],"version-history":[{"count":8,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":254,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/posts\/243\/revisions\/254"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/media\/245"}],"wp:attachment":[{"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlbackupfree.com\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}