Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 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. Lets Begin: We are going to start a series of blogs on configuring SQL server fail-over cluster and AG in multi-subnet environment. This is the 1st part …

Continue reading Configure SQL server fail-over cluster and Always On in multi-subnet environment-Part 1

PowerShell –SQL Automate Tutorial-11-Find SQL services running Service Account for Audit Purpose

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 …

Continue reading PowerShell –SQL Automate Tutorial-11-Find SQL services running Service Account for Audit Purpose

PowerShell –SQL Automate Tutorial-10

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 …

Continue reading PowerShell –SQL Automate Tutorial-10

SQL Database is 100 percent restored but restore command still running! Restore got stuck at 100%

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:- This may happen many times with us when we come across a situation where the SQL database has been restored with completion percentage 100% but still …

Continue reading SQL Database is 100 percent restored but restore command still running! Restore got stuck at 100%

PowerShell –SQL Automate Tutorial-9

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 …

Continue reading PowerShell –SQL Automate Tutorial-9

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 …

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 …

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 …

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 …

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

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: 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 …

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