SQL Server 2014 logo

How to uninstall SQL-Server 2014 Instance

In this article you will find a perfect way to uninstall a stand-alone instance of SQL Server 2014.

Pre-requisites to uninstall an SQL Server instance:

  • You must login system as local administrator with permission to log on as a service.
  • You must have minimum amount of physical memory with enough page size. ( page size = 2 times of physical memory )

Important points to be consider before uninstall SQL Server 2014:

  • Backup your database.
  • Drop/Delete local security groups.
  • All SQL server services must be stop. This would leads to successful removal of SQL Server.

Continue reading

SQL Server 2014 logo

SQL server 2014 stand alone installation

This article shows you step by step installation guide of SQL server 2012 ( stand alone ) on windows data center edition 64bit OS.

 

Download SQL Server 2012 from Microsoft website.

Following are the step by step guide with screenshot to install SQL server 2014:

Double click on Setup.exe this will pop up SQL server Installation Center prompt as below:

SQL server 2014 stand alone installation

SQL server 2014 stand alone installation

 

SQL server 2014 stand alone installation - SQL Server Installation Center

SQL server 2014 stand alone installation – SQL Server Installation Center

 

On SQL Server Installation Center wizard,

Click on Installation option available to left panel of SQL server Installation Center.

Then click on New SQL Server Stand-alone-installation or add features to an existing installation.

SQL server 2014 stand alone installation - SQL Server Installation Center

SQL server 2014 stand alone installation – SQL Server Installation Center

 

SQL server 2014 stand alone installation

SQL server 2014 stand alone installation

 

On Product Key wizard,

Provide your product key & click next.

In case you are evaluating SQL Server 2012 then go with Evaluation option.

SQL server 2014 stand alone installation - Product Key

SQL server 2014 stand alone installation – Product Key

 

On License Terms wizard,

Accept license terms & condition, click next.

SQL server 2014 stand alone installation - License Term

SQL server 2014 stand alone installation – License Term

 

On Install Rules wizard,

System Configuration Checker verifies your system Rules…

Click next.

SQL server 2014 stand alone installation - Install Rules

SQL server 2014 stand alone installation – Install Rules

 

On Install Setup Files wizard,

Downloading updates…

SQL server 2014 stand alone installation - Install Setup Files

SQL server 2014 stand alone installation – Install Setup Files

 

On Setup Role Wizard,

Select SQL Server Feature Installation radio button.

Click next.

SQL server 2014 stand alone installation - Setup Roles

SQL server 2014 stand alone installation – Setup Roles

 

On Feature Selection wizard,

Select feature according to your convenience.

Click next.

SQL server 2014 stand alone installation - Feature Selection

SQL server 2014 stand alone installation – Feature Selection

 

On Instance Configuration wizard,

Select Named instance radio button & give name of the instance.

In case of you wish to continue with default instance.

Click next.

SQL server 2014 stand alone installation - Instance Configuration

SQL server 2014 stand alone installation – Instance Configuration

 

On Server Configuration wizard, select Account Name as  NT AUTHORITY/NETWORK.

Set Startup Type as Automatic.

Click next.

SQL server 2014 stand alone installation - Server Configuration

SQL server 2014 stand alone installation – Server Configuration

 

On Database Engine Configuration wizard,

Select Mixed Mode radio button.

Enter your password.

Add current user.

Click next.

SQL server 2014 stand alone installation - Database Engine Configuration

SQL server 2014 stand alone installation – Database Engine Configuration

 

On Ready to Install wizard, Verify summary.

Click next.

SQL server 2014 stand alone installation - Ready to Install

SQL server 2014 stand alone installation – Ready to Install

 

On Installation Progress wizard, this will show you progress of software  installation.

SQL server 2014 stand alone installation - Installation Progress

SQL server 2014 stand alone installation – Installation Progress

 

On Complete Wizard, you will find list of features have been installed with status of completion.

SQL server 2014 stand alone installation

SQL server 2014 stand alone installation

 

By above steps you will accomplish installation of SQL Server 2014.

************************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

SQL Server 2014 logo

How to change SQL Server 2014 database compatibility level

The day before yesterday i have published my thoughts about “Truncate log file up to 504 KB – SQL Server 2008, 2008-R2 & 2012”, today i am going to explain how to change compatibility of SQL Server 2014 databases.

Note:
We need to change compatibility of our earlier version of databases in order to use new features of SQL Server 2014. ( i.e. 120 )

This can be achieve in two ways, one by GUI prompt, means with the help of Microsoft SQL Server Management Studio & second with the help of T-SQL Script.

 

1st: Microsoft SQL Server Management Studio: ( GUI )
To change compatibility of SQL server databases, open Microsoft SQL Server Management Studio & Expand Databases.

Right click on TestDB >> select Properties, as show below:

How to change SQL Server 2014 database compatibility level

How to change SQL Server 2014 database compatibility level

 

On Database Properties wizard, Select Options tab & go for the Compatibility level as SQL Server 2014 (120) and click Ok.

How to change SQL Server 2014 database compatibility level - Database Property

How to change SQL Server 2014 database compatibility level – Database Property

 

2nd: T-SQL

Issue following T-SQL in order to change compatibility of databases:

USE [master]
GO
ALTER DATABASE [TestDB] SET COMPATIBILITY_LEVEL = 120
GO

How to change SQL Server 2014 database compatibility level - T-SQL

How to change SQL Server 2014 database compatibility level – T-SQL

 

By above two methods we can change compatibility of databases in SQL Server 2014 as well as SQL Server 2008, 2008-R2 & 2012.

 

Is your database log file ( .ldf ) size is greater then the data file ( .mdf ) size, then refer my one of the blog to truncate log file up to 504 KB.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

SQL Server 2012 logo

Truncate log file up to 504 KB – SQL Server 2008, 2008-R2 & 2012

Yes, It’s true that we can truncate our log file up to the 504 KB with discard old log file & create new log file. This log truncation activity will help DBA in Capacity Management.

Note: 

  1. This can be done with only Database which have been configured with Full Recovery Mode option.
  2. Please consider full database backup before doing this activity so that In worst situation we will have safe backup in our hand.
  3. Refer my one of the post on SQL Server backup configuration to backup your SQL Server database.
  4. TestDB database is used to simulate for this activity.

After successful backup, Consider following step by step guide to truncate your DB log file:

Continue reading

SQL Server 2012 logo

How to apply SQL Server 2012 licences

Many times we successfully installed evaluation copy of SQL Server and not aware about the procedure to apply/upgrade licences.

This article, contains step by step instruction on how to upgrade Microsoft SQL Server 2012 Evaluation Edition to Microsoft SQL Server Enterprise Core-base licence.

Steps

// Run SQL Server 2012 installer by double-click on Setup file as below:

How to apply SQL Server 2012 licenses - Setup

How to apply SQL Server 2012 licenses – Setup

 

// Processing…

How to apply SQL Server 2012 licenses - Processing

How to apply SQL Server 2012 licenses – Processing

 

// Chose Maintenance tab.

How to apply SQL Server 2012 licenses

How to apply SQL Server 2012 licenses

 

// Chose Maintenance tab.

How to apply SQL Server 2012 licenses - Maintenance

How to apply SQL Server 2012 licenses – Maintenance

 

// Processing…

How to apply SQL Server 2012 licenses - Processing

How to apply SQL Server 2012 licenses – Processing

 

// Verifying Setup Support Rules, after verification click OK.

How to apply SQL Server 2012 licenses - Setup Support Rule

How to apply SQL Server 2012 licenses – Setup Support Rule

 

// Processing…

How to apply SQL Server 2012 licenses - Processing

How to apply SQL Server 2012 licenses – Processing

 

// Verifying Setup Support Rules, after verification click OK.

How to apply SQL Server 2012 licenses - Setup Support Rule

How to apply SQL Server 2012 licenses – Setup Support Rule

 

// Enter product key and click on Next button.

How to apply SQL Server 2012 licenses - Product Key

How to apply SQL Server 2012 licenses – Product Key

 

// Accepts the license terms and click Next.

How to apply SQL Server 2012 licenses - License Term

How to apply SQL Server 2012 licenses – License Term

 

// Select Instance

How to apply SQL Server 2012 licences - Select Instance

How to apply SQL Server 2012 licences – Select Instance

 

//  Verifying Edition Upgrade Rules, after verification click Next button.

How to apply SQL Server 2012 licences - Edition Upgrade Rule

How to apply SQL Server 2012 licences – Edition Upgrade Rule

 

// Click on Upgrade button.

How to apply SQL Server 2012 licences - Ready To Upgrade Edition

How to apply SQL Server 2012 licences – Ready To Upgrade Edition

 

// Upgrade successful with Succeeded status as below.

How to apply SQL Server 2012 licences - Complete

How to apply SQL Server 2012 licences – Complete

 

// You can verify licenses by right-click on instance name @ SQL Server Management Studio.

How to apply SQL Server 2012 licences - Server Property

How to apply SQL Server 2012 licences – Server Property

By above method we can apply/upgrade license to SQL server 2012.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

sql server 2008 logo

SQL server 2012 stand alone installation

This article show you step by step installation guide of SQL server 2012 ( stand alone ) on windows data center edition 64bit OS.

Pre-requisites for SQL server 2012:

  • .NET 3.5 sp1
  • .NET 4.0 (SQL server installs this during feature installation steps )
  • Windows Power shell 2.0
  • Minimum 6GB disk space
  • Minimum 1GB RAM, in case of Express edition it need 512MB

Continue reading

sql server 2008 logo

Daily Backup Configuration in SQL Server 2008

As we are aware of how backup is more important in day to day life, please consider following methodologies to backup SQL server 2008 databases through Microsoft SQL Server management studio.

We can backup database with 2 methods as below:

Method 1: Individual backup:
We can take individual database backup by following steps:

Step 1: connect to Microsoft SQL Server management studio. Continue reading