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 →

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:

 

 

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.

 

 

On Product Key wizard,

Provide your product key & click next.

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

 

On License Terms wizard,

Accept license terms & condition, click next.

 

On Install Rules wizard,

System Configuration Checker verifies your system Rules…

Click next.

 

On Install Setup Files wizard,

Downloading updates…

 

On Setup Role Wizard,

Select SQL Server Feature Installation radio button.

Click next.

 

On Feature Selection wizard,

Select feature according to your convenience.

Click next.

 

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.

 

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

Set Startup Type as Automatic.

Click next.

 

On Database Engine Configuration wizard,

Select Mixed Mode radio button.

Enter your password.

Add current user.

Click next.

 

On Ready to Install wizard, Verify summary.

Click next.

 

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

 

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

 

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.

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:

 

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

 

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

 

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.

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 →

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:

 

// Processing…

 

// Chose Maintenance tab.

 

// Chose Maintenance tab.

 

// Processing…

 

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

 

// Processing…

 

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

 

// Enter product key and click on Next button.

 

// Accepts the license terms and click Next.

 

// Select Instance

 

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

 

// Click on Upgrade button.

 

// Upgrade successful with Succeeded status as below.

 

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

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.

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 →