PowerShell / SQL Server / ConnectionContext.StatementTimeout

PowerShell / SQL Server / ConnectionContext.StatementTimeout
Recently I had an issue with a database backup PowerShell script one of our customer using. The script was working fine until trying to do a backup of the large database. During backup attempts script starts failing with the following error: Exception calling "SqlBackup" with "1" argument(s): "Backup failed for Server 'ServerName'. " At line:67 char:1 + $dbBackup.SqlBackup($s) + ~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : FailedOperationException Exception calling...
read more

Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)

Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
SQL SERVER 2019 Update Version: MSSQL 2019 RTM CU-9,Build: 15.0.4102.2,KB: KB5000642,Release Date: February 2021,Download: https://support.microsoft.com/en-us/topic/kb5000642-cumulative-update-9-for-sql-server-2019-97ad5c3e-e002-4b6d-b566-698bf70ca44a; Update Version: MSSQL 2019 RTM CU-8 SECURITY UPDATE,Build: 15.0.4083.2,KB: KB4583459,Release Date: January 2021,Download: https://support.microsoft.com/en-us/topic/kb4583459-description-of-the-security-update-for-sql-server-2019-cu8-january-12-2021-6a4cb3cc-6185-386b-be7b-ca1d6e652d16; Update...
read more