Activity overview
Latest activity by Bart430
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,
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.
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 ...
Thanks Pete / comments
Thanks Pete
Check backup in Query Analyzer?
Is there way I can run a scrip in Query Analyzer to see when the last backup was?
SQL Backup not starting
I am having a problem with SQL Backup not running. I restarted the SQLbackup service and it still won’t run. I can do a manual backup or use the Query Analyzer to run the same job script, but t...
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 ...
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...
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...
Scheduled Backup fails, no error
My backup ups have been failing, or not finishing. There is no log for the failed days. I tried to schedule a backup and it goes through half of the databases 12 out of 24 and then just stops. I...