November 18, 2008 at 9:47 am
When my job runs, I get the following error:
NT AUTHORITY\SYSTEM. SQL Backup failed with exit code: 667 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.
Is anyone knows why?
November 18, 2008 at 2:36 pm
Since there was already a Transaction log topic I figured I post my question here too. I'm a bit of a newbie so hopefully someone can help me out with this.
I'm using SQL 2000 and I have one db maintenance plan but it is producing two transaction log files. The directory had been changed to where it outputs the backups, and it's doing that just fine the db backup and the transaction log, for example to drive H:.
However the log file is being put in two different paths with different date and time stamps (two days apart) but with the same file name. I'm more familiar with 2005 than 2000 so I'm not sure how it could be producing two log files.
Any assistance is much appreciated.
Lisa
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply