x

daily backup in SQL 2005

when i make backup from maintinace plane and schadule it it dosn't work ? when i excute it by pressing right clik on the plane and select excute it starts and give me an error 22022 then how i can solve this problem?

more ▼

asked Oct 09, 2009 at 12:00 PM in Default

avatar image

suzan mater
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

This error is usually when SQL Agent is not running. In order for jobs to execute, SQL Agent must be configured and running.

http://support.microsoft.com/kb/911841

more ▼

answered Oct 09, 2009 at 12:13 PM

avatar image

Steve Jones - Editor ♦♦
5.2k 79 93 87

(comments are locked)
10|1200 characters needed characters left

Well, error 22022 would suggest it was an error with SQL Agent, maybe your job logs are full or you do not have right to start up SQL Agent?

Do you have sufficient rights to run jobs? Does the SQL Agent account have sufficient rights on the server?

more ▼

answered Oct 09, 2009 at 12:14 PM

avatar image

RickD
1.7k 2 3 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x247

asked: Oct 09, 2009 at 12:00 PM

Seen: 727 times

Last Updated: Oct 09, 2009 at 01:47 PM

Copyright 2017 Redgate Software. Privacy Policy