Database Recovery

How to Use DBCC CLONEDATABASE in SQL Server Older than 2014 SP2

DBCC CloneDatabase command is available only from SQL Server 2014 SP2; it is not available in previous versions. However, if you want to use this on versions older than 2014, then you can use this script. With 2014 SP2 Whenever there is a performance issue, you need a copy of the production database. However, it is not necessary that the copy you create should be with data to investigate the performance issue. So Microsoft introduced DBCC CLONEDATABASE in the service pack 2 for SQL SERVER...

Read more »

How to Fix SQL Server Configuration Manager with T-SQL Script

If your SQL Server Configuration Manager is showing an error on screen instead of SQL Server details, then it is time to fix it. Use this script and fix the problem. SQL Server configuration Manager: SQL Server Configuration manager is the GUI through which you can control SQL Server services and network protocols. Though you can start or stop SQL Server services using Microsoft Windows Services console, to control network protocols of your SQL instance you certainly need SLQ Server...

Read more »

How to Fix the Space Issues Caused by SQL Server

Several times SQL Server might be the reason for the space issue on disks. In this article, we will see what the root causes for this issue are and how we can fix it. Your SQL Server needs space. Many times SQL Server will need disk space. This might be because of growing data inside your database or unshrunk log files or undeleted backup files or undeleted, unwanted database files. Whatever the reason is, on a SQL Server, space on the disk is very important for database...

Read more »