Ray Mond (8/24/2010)
That script won't work on SQL Server 2000. You did post on a SQL Server 2005 forum after all.Run sp_who2, find if the BACKUP processes are being blocked, if so, by which process.
Do note that given the backup command you are using i.e.
BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename'.BAK'you are appending backup sets to the file, so after 4 days of backing up the 4 databases totaling 108 GB, and assuming most of the database space is used, you will run out of space on that external drive. Also, do check if the external drive has been formatted using FAT32 or NTFS.
I have run the backup again just with one of the Databases last night but the same thing happend, where the Backup states that it is still executing but nothing is being backed up.
I did run the following scripts to find out if anything is blocking the job:
sp_who2 and also
SELECT * FROM Master.dbo.sysprocesses WHERE blocked <> 0 and nothing seems to be blocking the job. I have been trying to backup the Databse for sometime now but it doen't seem to work, I've researched for the problem everywhere and I'm not having any luck. Is there anything I'm doing wrong?
Thank you.