Category Archives: SQL Server Backup

Overview of File-group(s) and Piecemeal database restore operations in SQL Server

So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series, we are going to discuss, the file-group and piecemeal database backup and restore process. Database “Backup and Restore” strategies are … Continue reading

Posted in SQL Server Backup | Tagged , , | Leave a comment

Backup and Restore Automation using SQLCMD and SQL Server agent

Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to the test or development environment. This is done so that the development or the test environment closely resembles the production … Continue reading

Posted in SQL Server Backup | Tagged , , | Leave a comment

Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler

  This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux and Windows machines. Here’s an outline of what this article is all about: Introduction Technical specifications How to load … Continue reading

Posted in SQL Server Backup | Tagged , | Leave a comment

Discuss smart database backup in SQL Server 2017

So far, we’ve discussed several phases of backup that starts with planning, creating, strategizing and implementing. In this article, we are going to see how database administrators can define the strategy to improve backup performance and efficiently manage backups in … Continue reading

Posted in SQL Server Backup | Tagged , , , | Leave a comment

Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques

Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance and administration of databases take a lot of work. As database administrators, we often tend to automate most of these … Continue reading

Posted in SQL Server Backup | Tagged , , | Leave a comment

SQL Server: Database snapshots vs Database backups

In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will help you decide when to use a database snapshot, and when to use a backup. In some cases, the database … Continue reading

Posted in SQL Server Backup | Tagged , | Leave a comment

Understanding database recovery models in SQL Server

A recovery model is a database configuration option that determines the type of backup that one could perform and provides the ability to restore the data or recover it from a failure. The recovery model decides how the transaction log … Continue reading

Posted in SQL Server Backup | Tagged , , , , , | Leave a comment

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the … Continue reading

Posted in SQL, SQL Server Backup | Tagged , , , , | Leave a comment