Category Archives: Backup and Restore

SQL Server In-Memory Optimized database backup and restore in action

A SQL Server backup and restore strategy is an essential process to safeguard and protect critical data. The vital role of any DBA is to minimize the risk of data loss and preserve data modifications at regular intervals of time. … Continue reading

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

Data Recovery : Page level restore in SQL Server

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

SQL Server database Backup and Restore strategies

One of the most important roles of a database administrator is to constantly protect the integrity of the databases and maintain the ability to recover quickly in case of a failure. In light of this, it’s critically important to have … Continue reading

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

Know How to Recover SQL Server Database Without Backup

Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF, NDF and LDF format. If SQL database lost due to disasters then backup acts as a silver lining. That is … Continue reading

Posted in Backup and Restore, SQL 2016 | Leave a comment

Understanding the Different States of SQL Database

Overview There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in SQL server. At once, the database is only in one state, which may be any one of the following: … Continue reading

Posted in Backup and Restore, databases_files, SQL | Leave a comment

Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB

Overview While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB command to check the problem, user gets database consistency errors. Causes Behind DBCC CHECKDB Consistency Errors The reason behind … Continue reading

Posted in Backup and Restore | Leave a comment

Restore a SQL Server Database with Different Methods

Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a common scenario that takes place every now and then lead to the loss of an enormous amount of data. In … Continue reading

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

PowerShell – SQL Databases Backup Status Report of Multiple Servers

  This post is a requirement from one of my blog reader. There are plenty of scripts available to get the backup status of the databases across multiple server. The  requirement is to read a server name and application names … Continue reading

Posted in Backup and Restore, PowerShell, SQL | Tagged , | 13 Comments

SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of us still use SQL Native method to do a Database Backup and Restoration. This post illustrates the quickest way of … Continue reading

Posted in Backup and Restore, Robocopy, SETVAR, SQL, SQLCMD, Uncategorized | Tagged , , , | 7 Comments