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.