Additional Protection

IT Administrators and MSPs will often backup systems using their software package of choice. But what happens when they overlook the SQL Backup toolset built into Microsoft SQL? They are missing out on the additional protection that can offer in a highly critical database. It is always best to not have all of your eggs in one backup methodology. This backup should also be stored on separate hardware so that neither a hardware nor software issue could impact your second backup option.

Responsibility

IT Administrators and MSPs will often backup systems using their software package of choice. But what happens when they overlook the SQL Backup toolset built into Microsoft SQL? IT Administrators may not have setup SQL backup jobs during a new software install but in most cases the software vendor is expecting IT Department to manage that job moving forward. When the vendor comes calling for a database to be restored or recovered they will place the blame straight onto the IT department if their database cannot be recovered. The software vendor probably even outlines that backups are a responsibility of the IT department once the software is installed in their contract with the customer. Take the time to make sure you manage not only your own backups but the vendor expected SQL backups to ensure you are always protecting a client or companies data.

Email Reports

SQL 2005 and above has a very consistent setup of emailing out the reports. This is really useful to make it easy for an administrator to check their SQL backups via email.

If you want to centralize your backups and monitor all from one source check out wwwbackupradar.com. We’ve also created a document that outlines the entire setup process at the link below:

http://support.backupradar.com/hc/en-us/articles/211808357-How-to-Setup-Database-Mail-for-SQL-Jobs

Backup Radar Logo Emblem
About Author
Founder & CEO

Patrick Leonard is Backup Radar’s Founder and Chief Executive Officer. He has been in the service provider industry for more than 15 years, and holds multiple technology engineering certifications. Patrick is an instrumental and driving force for My IT in Mandeville, LA. My IT has grown to become one of the largest and most successful service providers in Louisiana. As Chairman of the Board, Patrick continues to set the vision for the business as it continues its growth and success.

Sign Up For A Demo Today!

Let us show you how you can save time and money on your backup monitoring and compliance.

Get Started Now Request a Demo Join a Webinar