SQL Server System Databases – Restore System Databases
In the previous articles of the SQL Server System Databases series, we have learnt the purpose of...
How to Get Backup Status in SQL Server using Stored Procedure
Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Successful MySQL/MariaDB Backup and Recovery Strategies
A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential...
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL...
Configure Database Mirroring in SQL Server
Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database...
Creating Maintenance Plans in SQL Server
Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the...
Accelerated Database Recovery in SQL Server 2019
An Overview of Traditional Recovery As with all relational database systems, SQL Server guarantees...
Basics of SQL Server Task Automation
This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard...
How to Automate SQL Database Maintenance Tasks using SQLCMD
This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the...
Implementing Automated Database Backup and Restore with Default Means
Introduction You can find a lot of guides on how to backup and restore databases. In this one,...
