SQL Server Disaster Recovery Related Articles and Tips
SQL Server Disaster Recovery Tips
There can be certain scenarios when SQL Server is not starting because of configuration problems. During such scenarios one need to start an instance of SQL Server by using minimal configuration. In this article we will take a look at steps which one needs to follow to start SQL Server with Minimal Configuration to troubleshoot SQL Server configuration issues.
There can be certain scenarios when one needs to connect to an SQL Server Instance in a Single User Mode by using the Startup Option -m. For example, the need could be to recover a damaged system database such as Master, Model, MSDB etc or you may want to change the server configuration options. In this article we will take a look at steps which one needs to follow to Start SQL Server in Single User Mode.
This article demonstrates the steps that one needs to follow to start SQL Server without TempDB database or with minimal configuration.
Why SQL Server Log backups fails and Full backup succeeds? Learn how to Fix BACKUP detected corruption in the database log error in SQL Server
Due to an unplanned reboot of SQL Server one of the transactional log file of a database become corrupt. DBA noticed this issue once regular transactional log backup job started failing with BACKUP detected corruption in the database log error message. This article outlines the steps to be followed to fix BACKUP detected corruption in the database log error in SQL Server.
This article outlines the steps for Detecting Database Corruption Issues in SQL Server with the help of SUSPECT_PAGES table in MSDB database.
There can be a possibility that when you connect to an SQL Server Instance you will find the database being marked as SUSPECT. During such scenarios, you will not be able to connect to the database. In this article we will go through the steps which you need to follow to recovery a database which is marked as SUSPECT. The steps mentioned in this article works on SQL Server 2005 and higher versions.
This tutorial will give you compressive information on different database backup options which is available to a DBA or a Developer within SQL Server. The detailed topics mentioned in this tutorial will help you understand database backups in depth whether you are new to SQL Server or an Expert.
SQL Server Database Engine defines the size of virtual log files dynamically while creating or extending transactional log files in SQL Server. Virtual log files will not have a fixed size and one cannot predict the number of VLFs within the transactional log file. Internally, SQL Server will always try to maintain a smaller number of VLFs. However, there is no way for a database administrator to configure or set a fixed size for VLFs in SQL Server.
SQL Server Database Engine supports different startup options for SQL Server Database Engine Service. A database administrator can set the startup options very easily using SQL Server Configuration Manager. In this article we will explore startup options available in SQL Server Database Engine in detail.
This article demonstrates how to Detect Virtual Log Files in SQL Server Transaction Log File. The steps mentioned in this article are applicable on SQL Server 2005 and higher versions.
This article demonstrates how to Detect Virtual Log Files in SQL Server Transaction Log File. The steps mentioned in this article are applicable on SQL Server 2005 and higher versionsv
This article explains the steps to enable BACKUP CHECKSUM default configuration option using Trace Flag at instance level in SQL Server 2005 and higher versions. Once Trace Flag is turned on, CHECKSUM option is automatically enabled for all the BACKUP or RESTORE commands. The advantage of turn on this trace flag is you don’t need to rewrite all your existing backup scripts.
Using the PAGE_VERIFY CHECKSUM database option you can provide the most robust detection of database consistency problems caused by the system I/O path. If you use the PAGE VERIFY CHECKSUM option for a database, when SQL Server detects a page has been altered after it has been written to disk, SQL Server reports Msg 824 after reading the page back from disk.
How to Enable or Disable BACKUP CHECKSUM as Default Configuration in SQL Server 2014 Using SP_CONGIFURE?
This article explains the steps to enable or disable BACKUP CHECKSUM default configuration option at instance level in SQL Server 2014 using SP_CONFIGURE system stored procedure.
The hard part about becoming a DBA is getting the first job. No hiring manager wants to give a user with no track record the keys to the most valuable thing the company owns – the data. A single mistake by a DBA can cause an outage or loss of data that can result in loss of revenue or in the worst case the failure of the company. If you want to become a DBA you have to be ready for that opportunity by building skills above and beyond those you use at work – you need to learn the basic skills of a DBA. There is so much to learn; how do you decide what to learn first?
This article demonstrats the step you need to follow to restore a SQL Server Database from a Full Database Backup Using SQL Server Management Studio or via TSQL script.
Resource database is a read-only system database which is hidden from users and in this article we will discuss how to backup and restore Resource Database in SQL Server. DBA should backup Resource Database along with other System Databases in SQL Server as part of Disaster Recovery and most importantly document the location of each and every system and user databases.
Most of the Development and Test Database Servers will not have enough disk space to store both the database and backup files in order to perform the periodic database refreshes. In such scenarios, the best option will be to store the database backup files in a mapped network drive and perform the database restores from the mapped drive. However, things can become really complicated when the developer tries to restore the database using SSMS. This article explains how to achieve this with a simple trick.
Lets be Connected...
- Sign-up for Our Newsletter to Get Free SQL Server Tips and News to Built your Career
- Like MyTechMantra on Facebook to get updates on What's Happening in SQL Server