Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: Cannot open backup device. Operating system error 5(Access is denied.) Infrastructure: SQL server 2000 and onward Scenario: This is …

Continue reading Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: Only a member of the sysadmin server role can add a job for a different owner with …

Continue reading Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.  Note:  Best viewed in Internet Explorer 6 and above Error: No global profile is configured. Specify a profile name in the @profile_name parameter Infrastructure: SQL server 2005 …

Continue reading No global profile is configured. Specify a profile name in the @profile_name parameter

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: How to Change database owner for multiple DBs in one Go Scenario: Lets say, you want to …

Continue reading Change database owner for multiple DBs in one Go

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: Basic of PowerShell before diving into SQL automation with the help of PS Scenario: PS is most …

Continue reading PowerShell –SQL Automate Tutorial-1

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: Restore databases in SQL server fail-over cluster from backup files Scenario: Today We have been asked to restore …

Continue reading Error While Restoring Databases in SQL Server Cluster-Only Formatted Files On Which The Cluster Resource Of The Server Has Dependency Can Be Used

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above   Error: SSPI handshake failed with error code 0x8009030c in SQL errorlog Infrastructure: SQL server 2005/2008/2008R2/2012 and so on.. …

Continue reading Common SSPI handshake failed with error code 0x8009030c in SQL errorlog

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: Configure Log shipping in SQL server 2016. Scenario: Today I have faced very strange issue while configuring …

Continue reading Ls_Restore job failed every-time when executed through job throws error “Executed as user: Domain\UserAccount. The step failed.”

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: How to Fail-over MSDTC and Quorum Resources in Windows server 2003 R2 cluster. Scenario: Today I …

Continue reading How to Fail-over MSDTC and Quorum Resources in Windows server 2003/R2 cluster

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Implementation: How to get alerts for long running queries by duration. Scenario: Assume,you are asked to put alerts crossing …

Continue reading Get Alerts For Long Running Queries By Duration