Monthly Archives: May 2018

Backup and Restore Automation using SQLCMD and SQL Server agent

Posted on May 30, 2018 by Prashanth Jayaram

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

Posted on May 22, 2018 by Prashanth Jayaram

  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

Data Recovery : Page level restore in SQL Server

Posted on May 18, 2018 by Prashanth Jayaram

In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most of the time, performing a page-level restore suffices for database availability. A good backup strategy is a key to recovery … Continue reading →

Posted in Backup and Restore | Tagged , , , , , , | Leave a comment

Discuss smart database backup in SQL Server 2017

Posted on May 15, 2018 by Prashanth Jayaram

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

Mssql-cli Command-Line Query Tool

Posted on May 11, 2018 by Prashanth Jayaram

A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business are almost always a trade-off, and striking the right balance in a product in terms of the toolset is a … Continue reading →

Posted in SQL tools | Tagged | Leave a comment

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

Posted on May 8, 2018 by Prashanth Jayaram

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

Posted on May 4, 2018 by Prashanth Jayaram

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