Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day. The backup process is so essential that it usually requires distinct processes, checklists, and multiple database administrators to perform, and manage. Still, backup errors are among the most common, time-consuming, and costly problems administrators face on a regular basis. Realizing a backup has failed after it is too late is one of the worst feelings any database administrator could experience. Backup mistakes are often costly, always time-consuming, and can even cost database administrators their jobs.

This whitepaper presents a list of some of the most common backup mistakes, and provided insight into how to avoid them. Check this list of mistakes against the processes that are in place, and avoid that terrible “oops” moment. The whitepaper covers the following ten areas: Planning, protection, recovery, monitoring, testing, scheduling, knowledge, performance, management, and tools. Hopefully, this list of common backup mistakes helps to improve backup processes and helps to avoid the disasters associated with backup mistakes.

Presenter: Greg Robidoux

Greg Robidoux is the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server. Greg is also a co-founder of MSSQLTips.com. He has been working with SQL Server since 1999 and has authored many articles and delivered several presentations online and at local and national SQL Server events.

Register to read the full whitepaper.

Topics: Database Backup
Products: SQL Safe Backup