Problems scheduling backups | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problems scheduling backups

I am having problems scheduling backups. It seems pretty straight-forward, but will not work. I have tried a few different approaches. 1. in EM, under Management>Database Maintenance Plans, I have tried to set up a Database Maintenance Plan, but whenever I try to schedule a backup, it acts like it is fine, but when you close the DM plan and re-open the plan, the schedule always is gone and does not exist. I have also gotten errors stating that the plan could not be created because of a "int to smallint" conversion error, which absolutely baffles me. 2. In EM, under Management>Backups, I have tried to creat a backup with a schedule, but once again, the schedule disappears as soon as I close the dialog box and open it again. 3. I have right clicked on the db, go to all tasks>backup database, but I encounter the same problem in that I cannot schedule a backup. The backup itself works fine but I cannot seem to schedule any backup. Please help. This is driving me nuts!!! Archer
Check SQLAgent log and ensure it is started with privileged account. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I am logged in with full dba privileges. How would I check the Server log though? Thanks. Archer
To check SQLAgent log goto Enterprise Manager –> Management –> SQLAgent — right-click and see error log or on OS goto SQL installed path for instance mssql2kmssqllog directory. Is SQLagent started or not? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
This is the warning(it is not an error) that I am getting in the SQL Server Agent: [396] An idle CPU condition has not been defined – OnIdle job schedules will have no effect This seems like part of the problem. ANy clue as to how to fix it?? Thanks a bunch. Archer
That message in agent log shouldn’t have anything to do with your problem.
Can you just create a new job to backup a small database or system databases and schedule it to see the result. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Satya: Creating the job within the SQL Server Agent works. Thanks for all of your help. I had never used the SQL Server Agent before. Much appreciated. Archer
]]>