Category Archives: Backup and Restore

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