Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-03-07 : 07:01:40
|
| SQL server 2005 is installed but can not schedule a backup job.In the maintenance plan when selecting a new maintenance plan or maintenance plan wizard an error is produced which is:'Agent XPs' component is turned off as part of the security configuration for this server.I can see that the SQL Server Agent (Agent XPs is disabled). When trying to start this by right clicking on it in object explorer, the error message is 'unable to start service SQLAgent$SQL2005 on server serverName'. Service Logon failureHow can I scedule a back up job on this server?Any thoughts please? |
|
|
ganeshmpnet
Starting Member
1 Post |
Posted - 2006-03-25 : 05:38:23
|
| How can I scedule a back up job on this server?try this By creating a job you can schld a backup In job provide the command for backup DB in steps |
 |
|
|
|
|
|
backup schedule 2005