Backup

solarwinds

Native SQL Server Backup Types and How To Guide

When a disaster occurs, the ability to successfully restore SQL Server databases is fundamental for avoiding data loss. It’s not enough to rely on hardware and software technologies to replicate data because these technologies can go wrong or there can be multiple failures during a disaster, meaning you have to rely on backups to recover. SQL Server allows multiple types of backups, and a multitude of options to use with those backups.

N-able

Time to rethink backup

When was the last time you thought about your backup process? Is it one of those things you’ve just accepted to be the way it is? If so, your backup may be consuming more time and resources than it should. The state of backup technology has moved forward, and many of the old assumptions about it are no longer true. N-able recently interviewed about a dozen MSPs from around the world and heard first-hand what they discovered when they took a fresh look at backup.

solarwinds

Generating DDL Statements to Recreate Single Objects

Every database administrator (DBA) is—first and foremost—human. And everyone makes mistakes. It’s not the absence of mistakes but rather how you prepare for those mistakes that makes you a great DBA. Luckily, there are many ways to prepare for those mishaps, whether the errors are made by you or someone else on your team. One commonly made mistake is to drop an object in a database or accidentally delete data.

N-able

Gain peace of mind and leave backup complexity behind

Fast, reliable recovery is the whole reason we do backups in the first place. But the complexity of managing multiple backup products, juggling ever-growing local storage, keeping backup chains error free, and coordinating off-site backup storage can have a negative impact on the reliability that brings peace of mind. The more staff, people, and vendors are involved, the less likely your process will be consistent and error-free.