MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter























Latest SQL Server Tips







SQL Server Database Corruption Related Articles and Tips




SQL Server Database Corruption Related Articles and Tips | How to Fix Database Corruption Issues in SQL Server | Fix Suspect Database in SQL Server | Disaster Recovery in SQL Server

How to Start SQL Server with Minimal Configuration

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.

How to Start SQL Server in Single-User Mode

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.

How to Start SQL Server without TempDB Database

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.

How to Detect Corruption Issues in SQL Server Using Suspect_Pages Table?

This article outlines the steps for Detecting Database Corruption Issues in SQL Server with the help of SUSPECT_PAGES table in MSDB database.

Steps to Repair a Suspect Database in SQL Server?

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.

SQL Server Database Backup Options and Commands a Step by Step Tutorial with Examples

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.

What are Virtual Log Files in SQL Server Transaction Log File?

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.

Different Startup Options for SQL Server Database Engine Service

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.

How to Detect Virtual Log Files in SQL Server Transaction Log File

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.

How to Fix Virtual Log Files in SQL Server Transactional Log

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

How to Enable BACKUP CHECKSUM in SQL Server Using Trace Flag?

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.

How to Configure PAGE_VERIFY Option as CHECKSUM for all Databases in a SQL Server Instance

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.

Download Free White Paper: How to Become a SQL Server Database Administrator


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?



How to Restore a Full Database Backup in SQL Server?

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.

How to Backup and Restore Resource Database in SQL Server?

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.

FAQ: How to approach when a SQL Server Database restore fails in the middle due to network issues?

There can be an instance when you could be in the middle of restore a very large database on a clustered instance and due to certain network issue the failover had happened. You would discover that once the SQL Server Service came online on the second node the database which you were restoring shows (Restoring…). This scenario can be witnessed on a non-clustered instance as well especially when someone had accidentally restart SQL Server Service or the server is rebooted.

How to Configure Network Drive to be Visible for SSMS to Perform Database Backup and Restore?

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...




Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips