Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-01-21 : 15:48:56
|
| Team,my backup job have failed stating this error SQL Backup failed with exit code: 505 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 01:49:17
|
| What does the SQL Log say? |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-22 : 03:31:01
|
| Log the output of the step to a file and post the contents of the file. Are you backing up to a network location?- Lumbagohttp://xkcd.com/327/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-22 : 03:56:41
|
| Are you using a third party app to backups? or is this a standard BACKUP ?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-01-22 : 10:21:30
|
| Iam using Third Party Redgate tools.the error i get is the network folder is not accessable.but i have specified sharing permissions to network folder correctly. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-22 : 10:28:11
|
Your recent posts: Backup database failed Backup Failed Database Integrity Error Backup DB Error CHECKDB ERROR Duplicate Key DBCC CHECKDB Rebuild Index Why do you always have this kind of problems? Is it always the same server/environment? I am just curious 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-22 : 13:57:37
|
| Would you be able to post the actual sql statement that the Redgate tools generate?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 14:13:15
|
| I hope everyone isn't holding their breath ... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-25 : 03:22:16
|
| Well...I think the keywords here are "network folder is not accessable". You probably got this error for a reason...- Lumbagohttp://xkcd.com/327/ |
|
|
|
|
|
|
Backup database failed