database backup Archives - {coding}Sight https://codingsight.com/tag/database-backup/ Blog for SQL Server DBAs and Developers Mon, 21 Aug 2023 08:29:18 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png database backup Archives - {coding}Sight https://codingsight.com/tag/database-backup/ 32 32 SQL Server System Databases – Restore System Databases https://codingsight.com/sql-server-restore-system-databases/ Wed, 11 Aug 2021 10:15:54 +0000 http://codingsight.com/?p=15972 In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that comes as part of SQL Server installation and understood the best practices to be implemented for them. We have also understood the Tempdb and MSDB databases in more detail. Since Backup and …

The post SQL Server System Databases – Restore System Databases appeared first on {coding}Sight.

]]> How to Get Backup Status in SQL Server using Stored Procedure https://codingsight.com/a-dedicated-stored-procedure-to-get-the-latest-database-backup-status/ Fri, 21 May 2021 07:08:27 +0000 http://codingsight.com/?p=14000 Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data professionals. Monitoring those backups’ statuses is crucial. To make this task more straightforward, I have created a custom Stored Procedure. It will allow you to get the latest database backups’ (if any) …

The post How to Get Backup Status in SQL Server using Stored Procedure appeared first on {coding}Sight.

]]> Successful MySQL/MariaDB Backup and Recovery Strategies https://codingsight.com/successful-mysql-mariadb-backup-and-recovery-strategies/ Tue, 06 Apr 2021 14:32:10 +0000 http://codingsight.com/?p=12592 A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential to ensure data recovery at any point in time of the application workflow life cycle. Both MySQL and MariaDB offer solutions for these cases. This article will explore the existing options …

The post Successful MySQL/MariaDB Backup and Recovery Strategies appeared first on {coding}Sight.

]]> Backup and Restore MySQL Database Using mysqldump https://codingsight.com/backup-and-restore-mysql-database-using-mysqldump/ Wed, 17 Feb 2021 14:38:43 +0000 http://codingsight.com/?p=12073 The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool for generating backups in several formats or restoring MySQL databases. Note: On CodingSight you can also read about other MariaDB and MySQL backup strategies. For demonstration purposes, I created a demo database named …

The post Backup and Restore MySQL Database Using mysqldump appeared first on {coding}Sight.

]]> Configure Database Mirroring in SQL Server https://codingsight.com/configure-database-mirroring-in-sql-server/ Fri, 16 Oct 2020 08:37:04 +0000 https://codingsight.com/?p=10184 Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database server: a source database that you configure for the mirroring.    Mirror database server: a destination database that you must restore with NORECOVERY. Ideally, a mirrored database should be on a separate server. Witness Server: an optional …

The post Configure Database Mirroring in SQL Server appeared first on {coding}Sight.

]]> Creating Maintenance Plans in SQL Server https://codingsight.com/creating-maintenance-plans-in-sql-server/ Wed, 08 Jul 2020 08:36:58 +0000 https://codingsight.com/?p=9393 Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the databases that are hosted therein are kept in shape. Maintenance Plans offer a database administrator an opportunity to configure key tasks like indexing, statistics updates, backups, log cleanups, and others. In …

The post Creating Maintenance Plans in SQL Server appeared first on {coding}Sight.

]]> Accelerated Database Recovery in SQL Server 2019 https://codingsight.com/accelerated-database-recovery-in-sql-server-2019/ Fri, 31 Jan 2020 07:00:21 +0000 https://codingsight.com/?p=8480 An Overview of Traditional Recovery As with all relational database systems, SQL Server guarantees the durability of data by implementing crash recovery. Durability in the acronym ACID which refers to the characteristics of transactions in relational databases means that we can be assured that if the database fails suddenly, our data is safe. SQL Server …

The post Accelerated Database Recovery in SQL Server 2019 appeared first on {coding}Sight.

]]> Basics of SQL Server Task Automation https://codingsight.com/basics-of-sql-server-task-automation/ Tue, 24 Sep 2019 22:57:19 +0000 https://codingsight.com/?p=7799 This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard practices and a few examples to help beginners get started with SQL server automation. This article also highlights the importance of automating SQL server tasks to save time and effort required to do these …

The post Basics of SQL Server Task Automation appeared first on {coding}Sight.

]]> How to Automate SQL Database Maintenance Tasks using SQLCMD https://codingsight.com/automating-sql-database-maintenance-tasks-using-sqlcmd/ Tue, 09 Apr 2019 20:53:58 +0000 https://codingsight.com/?p=6628 This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the command prompt without using SSMS (SQL Server Management Studio). Typically, automating database tasks requires SSMS (SQL Server Management Studio) for scheduling jobs that run these tasks, but in this article, an alternative approach is …

The post How to Automate SQL Database Maintenance Tasks using SQLCMD appeared first on {coding}Sight.

]]> Implementing Automated Database Backup and Restore with Default Means https://codingsight.com/implementing-automated-database-backup-and-restore-with-default-means/ Tue, 19 Feb 2019 15:50:54 +0000 https://codingsight.com/?p=6317 Introduction You can find a lot of guides on how to backup and restore databases. In this one, we’ll show how this can be done using the default MS SQL Server means. This example will cover a number of approaches – from checking the database’s integrity before backing it up to restoring the database from …

The post Implementing Automated Database Backup and Restore with Default Means appeared first on {coding}Sight.

]]>