perfectly normal - floats do not convert to varchar the way you expect.

DECLARE @myInt float = 5555555;
SELECT CAST(@myInt AS VARCHAR(12)), RIGHT(REPLICATE('0',8) + CAST(cast(@myInt as int) AS VARCHAR(8)),8)

small error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one

This really should not be sent to standard output but rather redirected to a database or a file as volumes can be quite high.

Import-Module sqlps -DisableNameChecking

try

Import-Module sqlps -DisableNameChecking
$path='C:\localhost\serveur.txt'
$serveurs=Get-Content -path $path

$query="exec xp_readerrorlog 0,1"

foreach ($server in $serveurs) 
{
invoke-sqlcmd -Query $query -ServerInstance $server
}

you also need to take in consideration licensing - if your dev boxes are using a SQL Server Developer license (being it a MSDN one or not) they can not...

Issue with MS CRM is that you cannot insert data directly onto their tables as doing so will void the maintenance contract.
if this is a PasS or SaaS you...

1 - and how many files you backing up to?
2 - Using backup compression or not?
3 - How many cores on the server?
4 - Server Memory?

This is AWS - but it can easily go to next level of vm (m4.2large - 4 CPU, 16 GB RAM)

Azure you could easily go to a higher spec...

ìn case anyone wishes to look at it.

Its not a complex proc - its just a rather complex query 

alter procedure [Schema]. @DateFrom date
           ,...

Possible options

 - define the file as not having headers on it, load into a staging table with all columns defined similar to what you did, and then parse...

can you put code for that proc here? if it is the one I saw before it won't deal with dates datatypes.

Really you should not set it to off and should code accordingly.

But in either case it is doing what the manual says.
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-nulls-transact-sql?view=sql-server-2017

set...

You could setup a msa/gmsa just to perform that task - give it the required permissions to the folders on both servers, and have on a windows schedule on one...

As this is a error that occurs only at times, mainly at particular periods it leads me to believe the most likely cause is something on the network temporarily blocking...