• xp_cmdshell 'net use z: /delete'

    GO

    xp_cmdshell 'net use z: \\winvtblacka02\dbateam /USER:dbateam dbateam'

    GO

    Is the code before the backup begins, I don't use a SP. You are correct, it only backs up some of the databases. I looked this morning 41 databases backed up this morning as they where supposed to. 13 of them have yesterdays date or later and did not back up. However I have backup "all databases" selected. No errors in the logs.