Backup job Fails every time:

16 Feb 2005 11:43 AM

lakshminarayan iyer via SQLMonster.com

Dear Friends!
I have a scheduled job on my production server which always fails. When I
see the job history step details I can see 100 % backedup and along with
that I receive error
[SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
step failed.

Pl, guide me. Job fail isn't affordable on my production database.

I sincerly thank you!
S.Lakshminarayanan.

--
Message posted via http://www.sqlmonster.com

16 Feb 2005 12:26 PM

Keith Kratochvil

Can you try issuing a BACKUP DATABASE statement via T-SQL through Query
Analyzer? It would be helpful to see the errors (if there are any). Before
running the backup make sure that you have results set to text.

The syntax is easy enough:
BACKUP DATABASE SLNKMIL TO DISK = 'x:\SLNKMIL.bak' WITH INIT

--
Keith

Show quoteHide quote

"lakshminarayan iyer via SQLMonster.com" <fo***@SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@SQLMonster.com...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database
'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
>
> Pl, guide me. Job fail isn't affordable on my production database.
>
> I sincerly thank you!
> S.Lakshminarayanan.
>
> --
> Message posted via http://www.sqlmonster.com

16 Feb 2005 1:16 PM

Andrew J. Kelly

Is the database in Simple recovery mode? If so you can not do a log backup.

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"lakshminarayan iyer via SQLMonster.com" <fo***@SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@SQLMonster.com...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
>
> Pl, guide me. Job fail isn't affordable on my production database.
>
> I sincerly thank you!
> S.Lakshminarayanan.
>
> --
> Message posted via http://www.sqlmonster.com