SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Database Corruption: That Might Occur in an Environment using SQL Server

SQL server is the highly employed database service and is a highly advanced relational database management system, which is used on a large scale by the employees and the professionals. The improved user interface and the advanced features of MS SQL server makes it one of the highly used database… Read more

0 comments, 1,817 reads

Posted in on 6 October 2017

Solved : Microsoft SQL Server Error 3403

From its powerful internal structure, fast performance, and reliability, SQL server is now widely accessed by several enterprise users. It is used to deal with bulk transaction processing, business programs, and content management. The Microsoft SQL server is chosen for its high level security, scalability, and performance. Sometimes, corruption in… Read more

0 comments, 629 reads

Posted in on 15 June 2017

SQL Server Deadlock Performance Counter

End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem and then continue with their work. This restarting activity works for two to three weeks and after that, a point comes where the system gets… Read more

0 comments, 2,369 reads

Posted in on 27 February 2017

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

2 comments, 2,717 reads

Posted in on 18 January 2017

Steps to Restore Database from Backup File In SQL Server


In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster, or manage large amount of database onto the SQL server. However, users generally knows the way to create a backup… Read more

0 comments, 1,290 reads

Posted in on 21 September 2016

Reasons For Backup Failure In SQL Server and their Prevention


The entire idea behind a backup, is to protect any organization from the data loss and corruption. However, the question arises what happen if user will loose the backup. Many times we still hear about businesses breaking down due to data loss. In this article we will discuss the… Read more

0 comments, 4,285 reads

Posted in on 30 July 2016

SQL Server Error 3013: Restore Database is Terminating Abnormally

Overview of SQL Server Error 3013

One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more

0 comments, 6,832 reads

Posted in on 3 May 2016

SQL Log File Corruption and Possible Recovery Methods

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational database management system (RDMS) consisting of data definition language, data manipulation language and a data control language. The SQL database comprises of following three files:

  1. Primary Database files- Primary database file…

Read more

0 comments, 3,206 reads

Posted in on 21 March 2016

SQL Server Page Level Corruption And Resolution

SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard disk functioning failure, improper network establishment, or logical level of issues such as malware intrusion on the server storing data, repository being declared as out of limit. These… Read more

2 comments, 1,218 reads

Posted in on 2 September 2015

SQL Server Database Corruption Reasons and Recovery Solution

When database corruption occurs and found to have happened, there is a specific order in which operations are performed to decrease the limit of data loss and reduce downtime while the recovery process takes place. This means, the extent of corruption in all cases are not same and thus their…

Read more

5 comments, 8,834 reads

Posted in on 10 December 2014

SQL Server - Clustered Indexes and Non Clustered Indexes

To understand the concept of Clustered and Non Clustered indexes, it is important to understand the definition and functionalities of indexes first. An Index is a structure related to a view or table that speeds up the processes by quick retrieval of integrated rows from view or table.

There are…

Read more

1 comments, 1,774 reads

Posted in on 28 November 2014

SQL Server Disaster Recovery Planning

While administrating SQL Server database, one of the important part is to prepare a plan to work against potential disasters. A tried-and-tested design for backup and restore plays a major role in recovering database post disaster. However, some additional measures are to taken to ensure that system and database are…

Read more

0 comments, 7,365 reads

Posted in on 16 November 2014

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures in regular intervals of time to optimize the scalability and performance of the Server.
Several parameters that can be executed for stimulate Server performance are mentioned herein.

Server Level Configuration Check:

For tuning the…

Read more

0 comments, 1,056 reads

Posted in on 30 August 2014

SQL Server Recovery Models - Specifications and Significance!

SQL Server provides an efficient way of backing up the databases by logging all the transactions in log file but it becomes equally important to decide which data has to be backed up and which not by limiting the logging process. In this section we will discuss about the SQL…

Read more

0 comments, 1,030 reads

Posted in on 27 August 2014

Synchronization with Microsoft SQL Server Analysis Services

SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for business analysts. Implementation of SAAS gives an opportunity to users to ask compound query and convert it into actionable insight where information for better business decision making will be available.…

Read more

0 comments, 646 reads

Posted in on 15 August 2014