The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...

Things break and the DBA must be prepared for situations where a failure impacts the availability, integrity, or usability of a database. Reacting to failures and service disruptions is a key ...

The saying “always have a backup plan” is never more true than when it comes to your work files. Backing up computer files should be an ingrained routine in your business because the alternative could ...

A system failure wipes out all your data, corruption renders your data useless, an error leads to permanent deletion. Remember: Data loss always sneaks up on you. The ...

Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

You would be hard-pressed not to hear an IT department talk about virtualization. When virtualization was first born, IT departments went gangbusters using this revolutionary change to get better ...

You need to practice restoring your databases so when it becomes necessary in your live network, you’ll be prepared to do it right. It’s important to back up your databases, but it’s even more ...