August 7, 2008 at 10:13 am
All of the sudden, all of my backups job are failing since past 4 days. These backup jobs are in SQL Server 2000. We use SQLSafe to do the backups. The backup is acutally done through xp_ss_backup from master database.
This is the error message:
xp_ss_backup did not complete. An error(0,1) was encountered, please check the parameters and their values. Server instance: 100-DWICS-P-002, Database: ICS_EDI Msg 3013, Level 16, State 1, Server 100-DWICS-P-002, Line 1 BACKUP DATABASE is terminating abnormally. [SQLSTATE 01000] (Message 0) [SQLSTATE 42000] (Error 50000). The step failed.
Any insights on how to run this backup sucessfully will be appreicated.
Thanks!
August 7, 2008 at 1:24 pm
Watch which forum you post in, this is SQL2005. Anyway, check out the link below. Are these log backups or full? It appears logs based on the MS article. If it is, you'll need to do a full backup of the databases as someone did a truncate on a log backup. Possible someone switched a database from full mode to simple? Is so, exclude it from the backup routine or change it back to full mode.
http://support.microsoft.com/kb/272093
-- You can't be late until you show up.
August 7, 2008 at 2:14 pm
No. The recover models is still FULL. Job is failing both on log backup as well as database backup.
Appreciate your help on this.
Thanks!
August 7, 2008 at 4:11 pm
Please try running the t-sql command for backup statement(ran by sql-safe) under query analyzer manually and see what it shows in error message.
Manu
August 13, 2008 at 9:52 am
Here is the error message when I run it from query analyzer.
xp_ss_backup did not complete. An error(0,1) was encountered, please check the parameters and their values.
SQLsafe Freeware Edition CLI Version 4.7.727.5192
Copyright (c) 2004-2007 BBS Technologies, Inc., All Rights Reserved.
Connecting to Backup Agent on 100-DWICS-P-002...success. (4.7.727.5192)
Connecting to SQL Server 100-DWICS-P-002...success. (8.00.2040 SP4)
BACKUP ICS_EDI...FAILED.
Server instance: 100-DWICS-P-002, Database: ICS_EDI
1> 2> Msg 3013, Level 16, State 1, Server 100-DWICS-P-002, Line 1
BACKUP DATABASE is terminating abnormally.
(0 row(s) affected)
Server: Msg 50000, Level 16, State 1, Line 31
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply