I've noticed some prior issues with this in both 3.x and 4.x discussion groups, it has been suggested that it is a failure to write something greater than 1mb to a UNC path. A Red-Gate developer even posted a tool to test this theory. However, there really has been no specific response as to what the fix is, or at least I haven't found it yet. So my question is, I have a SQL job that uses the extended SP that works 99% of the time but every now an then it fails due to Error 112 (Not enough space on disk). The backup path is UNC and the file server drive that this UNC path points to has .3tb available at any given time which is more than enough to handle the 1gb of SQL backups. When the error occurs, we change the target location to a local drive and the command completes successfully. The version of SQLBACKUP is 3.x running on a SQL Version 2000 sp3a (8.00.760 ). The SQLBACKUP command in the SQL Job looks like
'-SQL "BACKUP DATABASE TO DISK = WITH COMPRESSION = 2, ' + ' LOGTO = , ' + 'password = [xxxxxxxxx], ' + 'init"'