ConnectionContext.StatementTimeout

Posted by Barac in Powershell, SQL Server on Sep 30th, 2018 | 0 comments

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

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

Posted by Barac in Updates on Sep 25th, 2018 | 0 comments

SQL SERVER 2019 Update Version: MSSQL 2019 RTM CU-8,Build: 15.0.4073.23,KB: KB4577194,Release Date: October 2020,Download: https://support.microsoft.com/en-us/help/4577194/cumulative-update-8-for-sql-server-2019; Update Version: MSSQL 2019 RTM CU-7,Build: 15.0.4063.15,KB: KB4570012,Release Date: September 2020,Download: https://support.microsoft.com/en-us/help/4570012/cumulative-update-7-for-sql-server-2019; Update Version: MSSQL 2019 RTM CU-6,Build: 15.0.4053.23,KB: KB4563110,Release Date: August 2020,Download:...