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

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 …

Continue reading Check database backup and restore completion percentage in SQL server