Comments
Sort by recent activity
Thanks Pete / comments
Thanks Pete
Pete, I checked and everything is seems to be correct. I have 5 jobs scheduled, Mon, Tues, Thur, Fri, and Sat. All set to go off at 10 PM. None of them have run since last week. The jobs are all enabled and have no end date checked. / comments
Pete, I checked and everything is seems to be correct. I have 5 jobs scheduled, Mon, Tues, Thur, Fri, and Sat. All set to go off at 10 PM. None of them have run since last week. The jobs are al...
Pete,
There is no log for that day. The job did not even attempt to start. Could it be a permissions issue? Both SQL backup and MS SQL Agent are running. MSSQL Agent is running under the Admin account, not mine, but I am a administrator. The OS is Windows 2000 Server, SP4 and SQL2000 Standard. / comments
Pete,
There is no log for that day. The job did not even attempt to start. Could it be a permissions issue? Both SQL backup and MS SQL Agent are running. MSSQL Agent is running under the Admin ...
Pete,
I will double check, but the job was running fine last week and I didnt change anything. / comments
Pete,
I will double check, but the job was running fine last week and I didnt change anything.
When I tried and do a manual backup, the program hangs at around 37%. The file is only about 32 mb and usually takes on a few seconds to backup. It does not give a error message or make an entry in the SQL backup log.
I rebooted the server and can do a manaul backup now without the program hanging. I will run a normal scheduled backup tonight. I am running full backups by the way with lowest compression. / comments
When I tried and do a manual backup, the program hangs at around 37%. The file is only about 32 mb and usually takes on a few seconds to backup. It does not give a error message or make an entry ...
Pete,
There are no logs, its seems that backup is not finishing, it just seems to stop after backing up model DB. I can do a manual backup of the DB's that are not getting backed up through the schedule. I will run the script through the Query Analyzer and see what happens. I am also going to delete all my scheduled backup jobs and recreate them. / comments
Pete,
There are no logs, its seems that backup is not finishing, it just seems to stop after backing up model DB. I can do a manual backup of the DB's that are not getting backed up through the sc...
I figured out the problem, SQL Backup is hanging when trying to backup the msdb. A few strange things are that I never recieved an error message and no backup log was created by SQL Backup.
Thanks,
Bart / comments
I figured out the problem, SQL Backup is hanging when trying to backup the msdb. A few strange things are that I never recieved an error message and no backup log was created by SQL Backup.
Thanks...