As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications
One of the most often made assumptions is that if you have made a backup of your database, your data is safe. Unfortunately, this is not true, and I’ll explain why, but don’t forget to verify SQL Server backup files after backup! SQLBackupAndFTP allows you to do this, in order to be absolutely sure that indeed, your data is safe!
Everyone knows that the most important task that any DBA has to be able to do is to take safe and reliable database backups. Large organizations or companies usually have a team of Database Administrators (DBAs) which execute these tasks and keep their data safe and easily accessible.