In order to backup a SQL Server to a NAS drive, all you need is to use SqlBak.
Backups are very important, and many organizations have different standards and rules for storing backups, from the more constrained from a security point of view which require you to store them locally (on-premises) to the organizations that allow their DBAs to store backups of their databases onto cloud storage services.
For those organizations that choose to store their backups locally, there are multiple storage solutions, one of which is owning your own NAS.
In order to organize the types of backups you make from your databases, you have multiple options when using SqlBak.
If you want, for example, to store FULL SQL Server backup on Amazon and differential backups to your FTP folder, SqlBak allows you to do this.
In the below article, we will show you how to do this, fairly easily, through the Task Schedule screen.
It’s important to verify SQL Server backup files after the backup process is complete.
Although the process can finish successfully this does not guarantee that the integrity of the data in the backup file is valid.
This will definitely cause some annoyance when later trying to restore the backup file.
In order to avoid this unwanted scenario, you should use verification options …
SQL Server maintenance is just as important as creating backups of your databases.
Unfortunately, there are many companies out there that install a SQL Server database or more without setting up first their maintenance plans.
Everything is perfect as usually at the beginning there is no problem, that is until a problem appears.
Restoring a SQL Server database from a Differential or Transaction log backup can’t be simpler when using SqlBak.
All that you have to do is press a few buttons and the restore operation will be complete. Read the article to find out how.
Encrypt SQL Server backups for an added level of security to your data.
Adding this option to your backups is extremely easy with the help of SqlBak.
Read the short tutorial in this article below to encrypt your backups.
Ever wondered if your backup tasks have finished successfully or not?
Would you like to get from SQL Server backup email notification to let you know if your task has successfully finished or not?
Read this article to find out how to do this, really easy!
We have extended the possibilities of SqlBak when selecting the backup destination so that now you can create a SQL Server backup to Azure directly from the browser!
Continue reading the article to find out how you can achieve this.
How to remove old SQL Server backups – quick tutorial:
Managing storage space occupied by your backups is a task that should not require a DBA’s time.
With SqlBak you can easily remove old SQL Server backups, periodically.
In this article we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.