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.

Archives: February 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, 623 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, 47,158 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, 460 reads

Posted in Ganapathi's MSSQLLover on 17 February 2017

Upcoming list of webinars

SQL folks, upcoming list of webinars from SQL PASS. 

Webinar title / Registration link / more info
Date / Time
Andy Yun
2/18/2017 9:00PM~10:30PM EST
"Reports on the Go: SSRS 2016 Mobile Reporting" https://attendee.gotowebinar.com/register/2771711963895711489
Steve Wake

Read more

0 comments, 222 reads

Posted in Ganapathi's MSSQLLover on 15 February 2017

Fix SQL Server Commvault Backup Failures After an Upgrade

One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the backups run through the Commvault backup tool. The error is:
Error Code: [30:325]
Description: Error encountered during backup. Error: [System.IO.FileNotFoundException:Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or…

Read more

1 comments, 752 reads

Posted in Ganapathi's MSSQLLover on 10 February 2017