I suggested him, first get data recovery tool to get the data from crashed server and then restore it to make it work, so application will be up.
Then, to overcome this kind of problem in future, I suggested him to always keep the database backup on another server and it is best to have database back up on another location too. He agreed with me that, and asked me a good question that: "Do you know if there is any kind of software by which I can schedule this and get out of this problem?"
As he needs the solution quickly, I checked it out some Tools and I come with the very cool tool "SQL SERVER Backup And FTP". This is very simple to use. This tool works as:
Here I have done following:
That's it and now we are out of stress to move database backup to another server or on FTP
Let's click on "Run now" to check it out.
After process is completed, Two zip files, pubs and SQLYoga is on Network path as well as on FTP.
Another cool feature is that, we can schedule Full Backup, Differential Backup, and Transaction Backup, so we can have very minimal amount of data loss.
Here, I have configured this software as:
Here, we assume that it is ok that we have 15 minutes data loss. It is depends on your application to decide this time window.
Let's take one case study to get more understanding about to restore these backups:
e.g. Database server is crashed at 8:20 AM, How can I restore my database from the backups?
Another, option is also available, to remove old Differential backup and Transaction backup. Once new differential backup is generated, there is no need to keep old differential backup. We only need to restore recent differential backup, so we can remove old differential backups. We can also remove all transaction log backup which are generated before Differential Log. SO to remove old backups, this software is also providing an option for the same, we just need to checked this option and that's it.
This software is also allowed following settings (advanced):
I like this tool, I recommend this tool to take back up and move it on FTP. Try to use it and let me know your comments
Posted by Tejas Shah on November 22, 2017
Posted by Tejas Shah on November 11, 2017
Posted by Tejas Shah on August 12, 2015
Posted by Tejas Shah on June 26, 2015
Posted by Tejas Shah on April 20, 2015