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

Ganapathi's MSSQLLover

Ganapathi Varma is an MCP Lead Database Administrator and Blogger. He works as Lead SQL Server DBA for CtrlS Datacenters pvt ltd, Asia's only Tier 4 datacenter. He is responsible for managing thousands of SQL instances providing database managed services, High Availability and Disaster Recovery. Other than SQL Server, he is also expertised in different datacenter technologies. He is the owner of MSSQLLover blog and he is fully dedicated to the SQL Server community. You can also visit the mssqllover fb page for more SQL blogs and follow FB group: SQLHyderabad.

Difference Between Restore with Recovery & Restore with Norecovery

Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration procedure means copying the backup and move it to the recovery point. SQL Database recovery involves rolling forward uncommitted transactions and… Read more

0 comments, 197 reads

Posted in Ganapathi's MSSQLLover on 13 December 2018

Calculating DTU's for Azure SQL Database

One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL Server licensing. Azure SQL Database pricing depends on the database service tier options ,such as Database Transaction units and the maximum…

Read more

0 comments, 469 reads

Posted in Ganapathi's MSSQLLover on 5 March 2018

Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only routing refers to the ability of SQL Server to route qualifying read-only connection requests to an available Always On readable secondary replica

Read more

0 comments, 300 reads

Posted in Ganapathi's MSSQLLover on 5 March 2018

How to Change the File Extension for a Data File


Link Below:

How to Change the File Extension for a Data File


In general, the file extensions for our SQL Data Files are .mdf, .ndf and .ldf.
But, a different file extension also work with SQL Server.

This article helps in finding a way to rename the file extensions.

Read more

0 comments, 351 reads

Posted in Ganapathi's MSSQLLover on 11 January 2018

Changing the Path for the Master Database


Link Below:


Changing the Path for the Master Database

This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving all the user databases and some system databases, including model, msdb and tempdb, but changing the path of…

Read more

0 comments, 311 reads

Posted in Ganapathi's MSSQLLover on 11 January 2018

Upgrade SQL Server Evaluation edition to license Edition of SQL Server

 The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and developing solutions. The edition has a built in expiry of 6 months from the time that you install it. 

One of my client doesn't have licensed…

Read more

0 comments, 8,444 reads

Posted in Ganapathi's MSSQLLover on 1 December 2017

Cumulative Update #1 for SQL Server 2017 RTM


The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.

Read more

0 comments, 489 reads

Posted in Ganapathi's MSSQLLover on 27 October 2017

Resolve Network Binding Order Warning in failover cluster

In this post, I’m going to talk about an issue that I found while running the cluster validation report. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
Rule “Network binding order” generated a warning.
The…

Read more

0 comments, 777 reads

Posted in Ganapathi's MSSQLLover on 22 July 2017

The Connection to the Primary Replica is not Active


In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  This error mostly appears when we try to join the adding replica to availability group or database to availability group using GUI and T-SQL.

Error 1


TITLE:…

Read more

10 comments, 1,477 reads

Posted in Ganapathi's MSSQLLover on 18 April 2017

Step by Step Configuring a Dedicated Network for Availability Group

One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage of using a separate network for replication is reduced latency and replication can still run without any latency issues during times of heavy network traffic issued by other applications or…

Read more

4 comments, 812 reads

Posted in Ganapathi's MSSQLLover on 10 April 2017

Step by Step Configuring AlwaysOn with Log Shipping

One of my clients came up with a requirement to use log shipping along with an AlwaysOn Availability Group. They cannot extend an AlwaysOn replica to the disaster recovery site for a few reasons listed below;
  • Infrastructure or staffing to maintain WSFC configurations between different sites
  • Delayed Recovery – In…

Read more

6 comments, 642 reads

Posted in Ganapathi's MSSQLLover on 4 April 2017

TempDB Database On a Local Disk for an FCI


Link Below:


TempDB Database On a Local Disk for an FCI


This article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL Server 2012/2014. This will reduce the I/O requests from the shared storage and overall it can improve performance.

Read more

0 comments, 338 reads

Posted in Ganapathi's MSSQLLover on 23 March 2017

Backup and Restore Strategies in SQL Server : A Brief Introduction

Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has been introduced for the management of data. The Main reason of introducing SQL Server backups and restore strategies in SQL Server…

Read more

1 comments, 1,248 reads

Posted in Ganapathi's MSSQLLover on 20 March 2017

Webinar: Performance Troubleshooting Using Wait Statistics by Paul Randal



Hi Folks, 

Join Webinar on Webinar: Performance Troubleshooting Using Wait Statistics. Tue 3/07/2017 from 10:30 PM to 11:45 PM IST

Click [Here] to join



Read more

0 comments, 452 reads

Posted in Ganapathi's MSSQLLover on 7 March 2017

Step By Step Logshipping configuration


Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups. This chapter explains the basic confi guration of
log shipping along with considerations for configuring the failover and failback within a log
shipping environment.

In this article, I will…

Read more

7 comments, 13,561 reads

Posted in Ganapathi's MSSQLLover on 2 March 2017

Everything on Always on Availability Groups series




Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups

AlwaysOn Availability Groups: Step by Step Setup Step by Step procedure to setup Always on Availability Groups



Always on troubleshooting: 

Read more

0 comments, 621 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

Step By Step configring Windows 2012 R2 fail over cluster



One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured in local disks.
AlwaysOn Availability Groups rely on the Windows Server Failover Cluster for failure detection and management of the Availability…

Read more

4 comments, 2,862 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

Webinar- SQL Server 2016 - Always Encrypted / Security


Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM

SQL Server has had ways to encrypt data in the past - for example, Transparent Data Encryption (TDE). This technology protects the data at rest and when the database files or backups are…

Read more

1 comments, 637 reads

Posted in Ganapathi's MSSQLLover on 23 February 2017

AlwaysOn Availability Groups: Step by Step Setup



An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases. Secondary databases are not backups. Continue to back up your…

Read more

8 comments, 48,824 reads

Posted in Ganapathi's MSSQLLover on 20 February 2017

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database


One of my client vCenter Server fails to start as below shown error in event logs.
Could not allocate space for object 'dbo.VPX_EVENT'.'VPXI_EVENT_USERNAME' in database 'VCDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,…

Read more

0 comments, 478 reads

Posted in Ganapathi's MSSQLLover on 17 February 2017

Older posts