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.
Deepak Bhardwaj
Author's posts
Jan 31
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: …
Jan 28
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 …
Jan 04
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.
Nov 24
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 …
Oct 23
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 …
Sep 29
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 …
Sep 28
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 …
Jul 23
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 …
Jul 10
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 …
