PowerShell –SQL Automate Tutorial-8

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-8

PowerShell –SQL Automate Tutorial-7

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-7

PowerShell –SQL Automate Tutorial-6

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-6

PowerShell –SQL Automate Tutorial-5

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-5

Could not apply log backup file .trn to secondary database Error: Directory lookup for the file .ndf failed with the operating system error 3(The system cannot find the path specified.).Use WITH MOVE to identify a valid location for the file. Problems were identified while planning for the RESTORE statement

Scenario: During production scripts deployment, someone from requester who actually had DBO permission on the database somehow executed the scripts without taking valuable review of scripts from DBA and broken the DR server which was configured with log shipping disaster recovery strategy. DBA monitoring alerts, notified us as priority 1 P1 ticket about this out of sync issue.   Workaround While working on this issue, … Continue reading Could not apply log backup file .trn to secondary database Error: Directory lookup for the file .ndf failed with the operating system error 3(The system cannot find the path specified.).Use WITH MOVE to identify a valid location for the file. Problems were identified while planning for the RESTORE statement

Check database backup and restore completion percentage in SQL server

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. Scenario: We often get database backup and restore tasks in SQL server while deployment of something or for testing purpose from developer. In this case, they may ask us to provide them update on backup and … Continue reading Check database backup and restore completion percentage in SQL server

PowerShell –SQL Automate Tutorial-4

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-4

PowerShell –SQL Automate Tutorial-3

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. In this series of tutorial, we will only walk through some … Continue reading PowerShell –SQL Automate Tutorial-3

PowerShell –SQL Automate Tutorial-2

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. Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets. Note:- Please click here to get 1st part of PowerShell –SQL … Continue reading PowerShell –SQL Automate Tutorial-2

Clustered role ‘Cluster Resource Group’ has exceeded its fail-over threshold. It has exhausted the configured number of fail-over attempts within the fail-over period of time

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. Scenario:- One of our UAT database environment which was setup with Active-Active fail-over cluster approach ran into inaccessible for the application and DBA was asked to take a look inside the database server. On checking from … Continue reading Clustered role ‘Cluster Resource Group’ has exceeded its fail-over threshold. It has exhausted the configured number of fail-over attempts within the fail-over period of time