Deepak Bhardwaj

IT Consultant of almost 10 years of experience with various business vertical in IT Infrastructure Service, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.

Author's posts

Error 42d during Fail Over SQL 2008R2 Enterprise in a Server 2008R2 Ent. Cluster

Hi Friends, Today morning I was just logging in Cluster instances to check certain parameters, while checking I found one of the SQL cluster is in failed state. Error Messages in Event logs are given below: ………………………………………………………………….. [sqsrvres] StartResourceService: StartService (MSSQLSERVER) failed. Error: 42d …………………………………………………………………. ……………………………………………………………………………… [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 42d) …………………………………………………………………………….. ……………………………………………………………………………. [sqsrvres] OnlineThread: …

Continue reading

Property Owner is not available for Database ‘Database Name’.

Hi Friends, One of my team member getting error message “Cannot execute as the database principal because the principal “Database Name” does not exist, this type of principal cannot be impersonated, or you do not have permission.”             There are multiple cause of this problem. May be your database is …

Continue reading

The trust relationship between this workstation and the primary domain failed in windows server 2008R2

Friends: Today I reached office and found some issue in  one the Database Instance, installed on Windows Server 2008R2 . Error: The trust relationship between this workstation and the primary domain failed. Solution: Disjoining and joining again the computer to the domain should fix the trust relationship issue.      

MySQL Workbench cannot load MYSQL.PROC

One of my team member starting to use MySQL Workbench tool especially for development task but not able to see the tables, stored procedures and views, Getting a strange error message: Error: Cannot load from mysql.proc. The table is probably corrupted Considering the error message. I tried to repair the table but no solution. Basically I …

Continue reading

Create MySQL User to Backup and Restore Databases!!

Create MySQL User to Backup and Restore  Databases It is always recommended to create a Backup and Restore User. I always recommend not to use MYSQL root user for database backup and restore. There is a slightly difference in the User privileges for Restore and backup.   User Privileges Required for Backup  and Restore are: Backup …

Continue reading

MySQL Binary Logging

How to enable MySQL binary logging. To enable MySQL binary logging stop the MYSQL service and then add the mentioned parameter in “my.cnf” configuration file. ………………………………………………………. log-bin=/var/lib/mysql/mysql-bin server-id = 1 innodb_flush_log_at_trx_commit=1 sync_binlog=1 ………………………………………………………. Once the above parameter added than start the MySQL service “Service  mysqld Start”.  This is the mistake which majority of people will do. I strongly recommend …

Continue reading

Up gradation of SQL Server 2005 to SQL 2012 Instance!!

High Level document for Implementation, Migration and Up gradation of SQL Server Database to SQL 2012 Instance!! One of my friend asked to have a High level document for Implementation, Migration and Up gradation of SQL Server Database to SQL 2012 This document might help you in your up gradation assignments. I appreciate if you …

Continue reading

SQL Server Error Log Consuming Lots of Disk Space

SQL Server Error Log Consuming lots of Disk Space!! I got a call from one of my Friend that in one of the SQL Server drive was very low on space. As a DBA my first question, This is a dedicated Data file or Log file drive, check the utilization of SQL Data and Log file or any folder …

Continue reading

Cluster network name resource ‘SQL Network Name (TESTDBCLU)’ failed to create its associated computer object

Cluster network name resource ‘SQL Network Name (TESTDBCLU)’ failed to create its associated computer object in domain ‘ABC.CORP.XYZ.IN’ for the following reason: Unable to update password for computer account. The text for the associated error code is: Access is denied. Please work with your domain administrator to ensure that: – The cluster identity ‘TESTOSCLUCTR$’ can …

Continue reading

SQLSERVER Broadcast ‘SQLSERVER 2016 CTP2 Available for download’

Friends : SQLSERVER 2016 CTP 2 available for download http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016?i=1

WP2Social Auto Publish Powered By : XYZScripts.com