Log Shipping error
derVampir
Posts: 3 New member
Hello,
I was just trying out Log Shipping with SQL Backup 8 in my testing environment: SQL Server 12 shipping to SQL Server 2016. When I set up log shipping using SQL Backup 8 (latest build) everything seemed fine but the restore job would fail every time. When I checked the job on the destination derver I found out that it had been created without any line breaks - the whole job code was one single line of code and therefore unusable. I manually updated the code and recompiled; now everything seems to be fine.
Here's what the Log Shipping Wizard created on the destination server:
Regards, Ralph
I was just trying out Log Shipping with SQL Backup 8 in my testing environment: SQL Server 12 shipping to SQL Server 2016. When I set up log shipping using SQL Backup 8 (latest build) everything seemed fine but the restore job would fail every time. When I checked the job on the destination derver I found out that it had been created without any line breaks - the whole job code was one single line of code and therefore unusable. I manually updated the code and recompiled; now everything seems to be fine.
Here's what the Log Shipping Wizard created on the destination server:
DECLARE @errorcode INTDECLARE @sqlerrorcode INTEXECUTE master..sqlbackup '-SQL "RESTORE LOG [Nummernkreise] FROM DISK = ''\Server01LogShippingLOG_Nummernkreise_*.sqb'' WITH NORECOVERY, MOVETO = ''C:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBackup''"', @errorcode OUT, @sqlerrorcode OUT;IF (@errorcode >= 500) OR (@sqlerrorcode <> 0)BEGINRAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @errorcode, @sqlerrorcode)END
Is this an error in SQL Backup 8 or is something wrong on my system?Regards, Ralph
Comments
Thank you for your forum post and sorry that you have encountered.
What is the full exact version number of the SQL Backup GUI in use (Help menu ->About)?
Also the full exact version number SQL Backup Server components version of the restoring server (right click the server in the GUI ->Select Properties ->In the table that appears 'service application version' and 'SQL Backup version')?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com