Backup SQLserverAgent is stopped

Hi
I m trying to make a backup of a SQL database on I m getting the message
SQLserverAgent is stopped on the target '(local)' server
what is this and what do I have to do to fix it
thanxSQL Server Agent is the built in scheduler service for SQL Server. This is
usually how backups are done. Maybe if you can explain exactly how you are
attempting to issue a backup we can give a more precise answer.
--
Andrew J. Kelly SQL MVP
"hershel" <hershel@.discussions.microsoft.com> wrote in message
news:62A861BE-B5A5-4568-BE9C-9E52081A5F9C@.microsoft.com...
> Hi
> I m trying to make a backup of a SQL database on I m getting the message
> SQLserverAgent is stopped on the target '(local)' server
> what is this and what do I have to do to fix it
> thanx
>|||I just want make backup and I got this error message
"Andrew J. Kelly" wrote:
> SQL Server Agent is the built in scheduler service for SQL Server. This is
> usually how backups are done. Maybe if you can explain exactly how you are
> attempting to issue a backup we can give a more precise answer.
> --
> Andrew J. Kelly SQL MVP
>
> "hershel" <hershel@.discussions.microsoft.com> wrote in message
> news:62A861BE-B5A5-4568-BE9C-9E52081A5F9C@.microsoft.com...
> > Hi
> >
> > I m trying to make a backup of a SQL database on I m getting the message
> > SQLserverAgent is stopped on the target '(local)' server
> > what is this and what do I have to do to fix it
> >
> > thanx
> >
>
>|||But how did you make the backup? If you simply typed BACKUP DATABSE xxxx in
Query Analyzer it would not give you any such message. You must have done
something associated with SQL Agent.
--
Andrew J. Kelly SQL MVP
"hershel" <hershel@.discussions.microsoft.com> wrote in message
news:A820A21F-8053-4CBC-863A-89963C7BFF6C@.microsoft.com...
>I just want make backup and I got this error message
> "Andrew J. Kelly" wrote:
>> SQL Server Agent is the built in scheduler service for SQL Server. This
>> is
>> usually how backups are done. Maybe if you can explain exactly how you
>> are
>> attempting to issue a backup we can give a more precise answer.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "hershel" <hershel@.discussions.microsoft.com> wrote in message
>> news:62A861BE-B5A5-4568-BE9C-9E52081A5F9C@.microsoft.com...
>> > Hi
>> >
>> > I m trying to make a backup of a SQL database on I m getting the
>> > message
>> > SQLserverAgent is stopped on the target '(local)' server
>> > what is this and what do I have to do to fix it
>> >
>> > thanx
>> >
>>|||I was first trying to do it in the enterprise manager and I got the error
with SQLserverAgent, but I m trying to do it in the Query Analyzer but I m
not sure how to specify that back drive should be my USB which for example
â'f:\sqlbackupâ'
"Andrew J. Kelly" wrote:
> But how did you make the backup? If you simply typed BACKUP DATABSE xxxx in
> Query Analyzer it would not give you any such message. You must have done
> something associated with SQL Agent.
> --
> Andrew J. Kelly SQL MVP
>
> "hershel" <hershel@.discussions.microsoft.com> wrote in message
> news:A820A21F-8053-4CBC-863A-89963C7BFF6C@.microsoft.com...
> >I just want make backup and I got this error message
> >
> > "Andrew J. Kelly" wrote:
> >
> >> SQL Server Agent is the built in scheduler service for SQL Server. This
> >> is
> >> usually how backups are done. Maybe if you can explain exactly how you
> >> are
> >> attempting to issue a backup we can give a more precise answer.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "hershel" <hershel@.discussions.microsoft.com> wrote in message
> >> news:62A861BE-B5A5-4568-BE9C-9E52081A5F9C@.microsoft.com...
> >> > Hi
> >> >
> >> > I m trying to make a backup of a SQL database on I m getting the
> >> > message
> >> > SQLserverAgent is stopped on the target '(local)' server
> >> > what is this and what do I have to do to fix it
> >> >
> >> > thanx
> >> >
> >>
> >>
> >>
>
>|||BooksOnLine is a wonderful resource for details such as this but here is a
start:
BACKUP DATABASE YourDB TO DISK = 'F:\sqlbackup'
But you have to be careful when using a device such as this. Backups are
always done under the account sql server is running under. So if you map a
drive under another account or the account sql server is using does not see
the device as F: it will fail.
--
Andrew J. Kelly SQL MVP
"hershel" <hershel@.discussions.microsoft.com> wrote in message
news:2763B9E0-9A91-4724-A8B8-77C6FAB0EAA6@.microsoft.com...
>I was first trying to do it in the enterprise manager and I got the error
> with SQLserverAgent, but I m trying to do it in the Query Analyzer but I m
> not sure how to specify that back drive should be my USB which for example
> 'f:\sqlbackup'
>
> "Andrew J. Kelly" wrote:
>> But how did you make the backup? If you simply typed BACKUP DATABSE xxxx
>> in
>> Query Analyzer it would not give you any such message. You must have
>> done
>> something associated with SQL Agent.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "hershel" <hershel@.discussions.microsoft.com> wrote in message
>> news:A820A21F-8053-4CBC-863A-89963C7BFF6C@.microsoft.com...
>> >I just want make backup and I got this error message
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> SQL Server Agent is the built in scheduler service for SQL Server.
>> >> This
>> >> is
>> >> usually how backups are done. Maybe if you can explain exactly how
>> >> you
>> >> are
>> >> attempting to issue a backup we can give a more precise answer.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "hershel" <hershel@.discussions.microsoft.com> wrote in message
>> >> news:62A861BE-B5A5-4568-BE9C-9E52081A5F9C@.microsoft.com...
>> >> > Hi
>> >> >
>> >> > I m trying to make a backup of a SQL database on I m getting the
>> >> > message
>> >> > SQLserverAgent is stopped on the target '(local)' server
>> >> > what is this and what do I have to do to fix it
>> >> >
>> >> > thanx
>> >> >
>> >>
>> >>
>> >>
>>