Unable to Shrink Tempdb Data and Log files

Unable to Shrink Tempdb Data files have grown large.

You may receive this error message.

File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty Continue reading

Advertisements

SQL Server Backup Format

Below given codes will create a standard Backup File in the designated disk. Continue reading

SQL Server : Point – in – Time Recovery

How to perform point-in-time-recovery? Continue reading

Start SQL Server in Single User Mode

Today I received a mail from one of my Blog reader. He wanted to know how to start SQL Server in Single User mode?

 Continue reading 

SQL Server : How to move or add Tempdb data and log files

Problem:

– TempDB has grown big and the current disk drive does not have enough space.
– Adding TempDB data file to another physical drive helps to improve performance, as they can be read simultaneously.

Solution : Here I have tried to explain how can we move tempdb data files from one place to another. Continue reading

MOVING SYSTEM DATABASE TO A DIFFERENT LOCATION IN SQL SERVER 2008 R2

Scenario:

A couple of days back, I was examining the configuration of one of our production DB servers. This server was involved in Merge Replication. All the database files on this server were dumped on one SAN drive of a subsequently small size. The replication cleanup job for some reasons was not able to delete the historical records from the system tables present in the distribution database due to which all of a sudden the drive which contained the data files as well as the log files got filled up hardly leaving any space for the SQL Server to start. After a detailed examination of the system, I came up with the following recommendations: Continue reading

Collection of useful Commands for SQL Server DBA

In this article I have tried to give as much as I can from my real time experience. You may try these commands on one of your test/pre-production server.
Continue reading