MS SQL Server

now browsing by category

 

Different ways to start and stop DB Services

There are many ways to start and stop DB services in SQL Server. Here I am writing down most frequently used in real time by DBA.       Using SQL Server Configuration Manager                                  Read More

Different states/Modes of database in SQL Server

In this article, I want to explain about different states or sometimes we call modes of database in SQL Server. We have different modes of database in SQL Server. These are mentioned below. I will go through each mode one by one. Online Mode Offline Mode Restoring Mode Recovery Mode RecoveryRead More

Recovering database from suspect mode

Recently I got an issues in one of the database in production environment where I found a database is in suspect mode. It happens some time because of services re-start activity which happened in my case. In such scenarios, we need to repair the database to make it online. TheseRead More

Installation of SQL Server 2012 on Windows

Installation of SQL server 2012 Enterprise Edition on Windows To install SQL Server 2012, we need to follow below mentioned steps: step 1: Go to the location where setup file of SQL Server is kept. Right click on the setup file and run this as an administrator. Step 2: InstallationRead More

Introduction to SQL Server

MicroSoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on anotherRead More