Category Archives: Backup and Restore

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