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: How to Change database owner for multiple DBs in one Go Scenario: Lets say, you want to change DB owner for multiple DBs to say ‘SA’ in case … Continue reading Change database owner for multiple DBs in one Go

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: Basic of PowerShell before diving into SQL automation with the help of PS Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. … Continue reading PowerShell –SQL Automate Tutorial-1

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 Implementation: Restore databases in SQL server fail-over cluster from backup files Scenario: Today We have been asked to restore few databases from mirrored backup files The backup files and mirror … 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