Tuesday, March 27, 2012

Backup fail

hi Friends,
How r u? i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.codecomments.com ***
Hi
"rohit taru" wrote:

>
> hi Friends,
> How r u? i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John

No comments:

Post a Comment