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

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

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

Continue reading 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. Note:- …

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

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

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:- Well, it is always a good practice to use DMA tool by Microsoft to check any compatibility issues before upgrading to higher version of SQL …

Continue reading Data Migration Assistant (DMA) to check SQL server compatibility issues for migrating one version to higher version

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:- As we all know that TLS 1.0 is outdated protocol, it was released somewhere in 1999 which is now no secure and most vulnerable hence …

Continue reading TLS 1.0 & MSSQL Server Dependencies

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:- It doesn't happen so often as company always use the licensed SQL server but sometime on Development or Lab environment people use the evaluation edition …

Continue reading SQL Server evaluation period has expired:Unable to start SQL services

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:- Okay, so before upgrading SQL server version to higher, we need to have setup files in place first. Please see this link for list of …

Continue reading Download SQL server 2014/2016/2017/2019 setup file