Backup Job Sometimes Fails

Hi

We have a nightly job on a production server which backs up all databases
(about 90 on the server)

Sometimes it'll only backup some of them, yet it reports success.

Our proc to manage the process is below:

Any ideas on what we need to do to make it reliable ?

-----------------------------------------------------

DECLARE @DB_Name varchar(32)
DECLARE @Backup_Path varchar(255)
DECLARE @Backup_Name varchar(255)

DECLARE DB_Cursor CURSOR FOR SELECT NAME FROM sysdatabases

OPEN DB_Cursor

FETCH NEXT FROM DB_Cursor INTO @DB_Name

WHILE @@FETCH_STATUS = 0
BEGIN
IF @DB_Name <> 'tempdb' AND @DB_Name <> 'model'
BEGIN
print '--------------------------------<< ' + @db_name + '
>>--------------------------------'
SET @Backup_Path = N'd:sql2005backups
ightly' + @DB_Name + 'Daily' +
'.bak'
SET @Backup_Name = @DB_Name + N' backup'
BACKUP DATABASE @DB_Name TO DISK = @Backup_Path WITH INIT
print ''
END
FETCH NEXT FROM DB_Cursor INTO @DB_Name
END

Print "Finished backing up the databases"

CLOSE DB_cursor
DEALLOCATE DB_cursor