Tag: database backup

SQL Server System Databases – Restore System Databases

12:15 Database administation, Database Optimization & Structure

In the previous articles of the SQL Server System Databases series, we have learnt the purpose of...
Read More

A Dedicated Stored Procedure to Get the Latest Database Backups Status

09:08 Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Read More

Successful MySQL/MariaDB Backup and Recovery Strategies

16:32 Database administation

A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential...
Read More

Backup and Restore MySQL Database Using mysqldump

16:38 Tools & technologies, Utilities & Extensions

The current article focuses on applying the mysqldump utility to backup and restore MySQL...
Read More

Configure Database Mirroring in SQL Server

10:37 Tools & technologies, Utilities & Extensions

Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database...
Read More

Creating Maintenance Plans in SQL Server

10:36 Database administation, Database Optimization & Structure

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the...
Read More

Accelerated Database Recovery in SQL Server 2019

09:00 Database administation, Database Optimization & Structure

An Overview of Traditional Recovery As with all relational database systems, SQL Server guarantees...
Read More

Basics of SQL Server Task Automation

00:57 Automation, Database administation

This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard...
Read More

How to Automate SQL Database Maintenance Tasks using SQLCMD

22:53 Automation, Database administation

This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the...
Read More

Implementing Automated Database Backup and Restore with Default Means

17:50 Automation, Database administation

Introduction You can find a lot of guides on how to backup and restore databases. In this one,...
Read More