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 / BETA (15.0.1000.34)

Microsoft SQL Server 2019 / BETA (15.0.1000.34)
SQL SERVER 2019 Update Version: MSSQL 2019 BETA (CTP2.2), Build: 15.0.1200.24, Release Date: December 2018, Download: https://docs.microsoft.com/en-us/sql/sql-server/sql-server-ver15-release-notes?view=sqlallproducts-allversions; Update Version: MSSQL 2019 BETA (CTP2.1), Build: 15.0.1100.94, Release Date: November 2018, Download: https://docs.microsoft.com/en-us/sql/sql-server/sql-server-ver15-release-notes?view=sqlallproducts-allversions#ctp-21-october-2018; Update Version: MSSQL 2019 BETA (CTP2.0), Build: 15.0.1000.34, Release Date:...
read more