transcation back up failed

Question

transcation back up failed

nag4.net

SSC Veteran

Points: 288
More actions
July 15, 2010 at 7:42 am

#224148

A job is scheduled to run every 6 hrs to back up the transcation logs . But today it is failed with the following the error.
SQL Backup failed with exit code: 667 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Which 3rd party backup tool are you using?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nag4.net SSC Veteran Points: 288 More actions · Answer 2

nag4.net

SSC Veteran

Points: 288

July 15, 2010 at 8:01 am

#1193497

Red gate sqlbackup 6

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Anything in the application log?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mohd.sql Old Hand Points: 384 More actions · Answer 4

Hi Gail,

What r t major reasons for the backup and restore jobs failure....????

Thanks

Aashu

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Please post new questions in a new thread.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jsatish13 SSC Rookie Points: 49 More actions · Answer 6

nag4.net (7/15/2010)
Hi,
I have the log backup, that was scheduled for every 6 hrs(legato).But today it was failed.
And i have tried to execute manually but it gives an error that
received a retryable network error : Remote system error

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 7

SQL Backup failed with exit code: 667 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

It's time to pay money 😉

667 -- Trial period has expired. Contact licensing@red-gate.com and tell us you are evaluating SQL Backup.

Learning SQL Backup - 6.2 Error code reference

http://www.red-gate.com/supportcenter/Content?p=SQL%20Backup&c=SQL_Backup/help/6.2/SBU_Errorcodereference.htm&toc=SQL_Backup/help/6.2/toc.htm

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

Dev (11/12/2011)

SQL Backup failed with exit code: 667 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

It's time to pay money 😉

667 -- Trial period has expired. Contact licensing@red-gate.com and tell us you are evaluating SQL Backup.

Learning SQL Backup - 6.2 Error code reference

http://www.red-gate.com/supportcenter/Content?p=SQL%%5Burl%5D20Backup&c=SQL_Backup/help/6.2/SBU_Errorcodereference.htm&toc=SQL_Backup/help/6.2/toc.htm%5B/url%5D%5B/quote%5D

You're learning fast... see how google is useful

/joke

:hehe: