-->
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, 412 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, 15,125 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, 181 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
Speaker
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, 114 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=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or…

Read more

1 comments, 325 reads

Posted in Ganapathi's MSSQLLover on 10 February 2017