olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

DataDomain - Incorrectly formatted #700

Open ctenersight opened 1 year ago

ctenersight commented 1 year ago

https://github.com/olahallengren/sql-server-maintenance-solution/blob/9ee2513a4156a7e7252a1cb430173421b3c71053/DatabaseBackup.sql#L3710

Failing to complete backups for 50+ databases that are scheduled when writing log files.

Update line 3710: SET @CurrentCommand = 'declare @t table (msg nvarchar(MAX)); DECLARE @ReturnCode int; insert into @t (msg) EXECUTE @ReturnCode = dbo.emc_run_backup '''

"Msg 0, Sev 0, State 1: Unknown token received from SQL Server [SQLSTATE HY000] String data, right truncation [SQLSTATE 01004] Msg 16389, Sev 16, State 1: The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted. [SQLSTATE 08S01]"

https://www.dell.com/support/kbdoc/en-ca/000168243?l NetWorker MS Appagent SQL DB backups using T-SQL script fail Dell Canada.pdf ang=en

eltonkerber commented 1 year ago

I fixed the code as the recommendation, just in case anyone else need. DatabaseBackup.txt

olahallengren commented 3 weeks ago

Do you know if this is still needed with the latest version of Data Domain Boost?