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 ...
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 ...
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 ...
As humanity's use of all kinds of technology has grown, terms like backup are no longer unfamiliar to the majority of people. Of course, the concept of a backup existed long before it came to be named ...
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 ...
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 ...
Recently, I had a chance to test the community edition of Zmanda Recovery Manager for MySQL. I was partly testing to make sure it worked with MariaDB, Monty Program's drop-in replacement for MySQL, ...
Restoring personal data and operating systems when disaster strikes can be filled with gray areas and worries that the backup tool does not miss any critical files. The process can be daunting for ...