Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Backup Expand / Collapse
Author
Message
Posted Thursday, January 21, 2010 1:50 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
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.
Post #851565
Posted Thursday, January 21, 2010 2:57 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
dba_neo (1/21/2010)
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.


Seems this msg is not coming from the SQL Server engine!!! Are you using third party application for BCK!?


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #851593
Posted Thursday, January 21, 2010 3:01 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
yes,iam using redgate tools
Post #851594
Posted Thursday, January 21, 2010 3:11 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 20,744, Visits: 32,559
Found on Redgates' site via Google:

505 -
No SQL Backup file name entered.
Check that the length of the path name does not exceed the number of characters for your operating system.
If you are backing up directly to a network share (not recommended), ensure the network share already exists, and that the startup user for
the SQL Backup Agent Service has full permissions for the network share (see Using SQL Backup to back up to a network share).
To check the SQL Backup Agent Service permissions, run the following command:

execute master..sqbutility 999, 'RWE', '\\testsrv\backup'

If the agent has read (R), write (W), and execute (E) permissions, the command returns 1; 0 indicates failure.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #851599
Posted Thursday, January 21, 2010 4:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
when i execute the command i got the result as the remote share folder cant be accessed,i have specified the sharing permissions for the folder correctly,even it was not accessed.I have followed the steps specified by redgate in the article how to take backup to a network share,but of no use.
Post #851632
Posted Thursday, January 21, 2010 4:28 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 17,844, Visits: 15,796
Please provide The sql statement that Redgate generates for the backup plan.


Are you using the gui, or just scripting it out manually?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #851637
Posted Wednesday, January 27, 2010 12:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
Hi team,

BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_3A007C8D-A295-4850-AB44-4D03AE9E1614'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

i got this statement in error log for backup databases
Post #854678
Posted Wednesday, January 27, 2010 1:16 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 20,744, Visits: 32,559
Okay, gut feeling, network glitch or a permissions issue on the network share you are attempting to write the backup file.

Please go check the Redgate site for their error messages. That would be a good place to start. they may also have a forum where you can ask questions and you may get better answers there as this is their product.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #854697
Posted Wednesday, January 27, 2010 1:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 6:35 AM
Points: 65, Visits: 312
May be a permission issue. Check the permissions of the service accounts of sql server. If you are running the backup in a job, make sure that the account under which SQL Server Agent is running must have access to the share location.
Post #854711
Posted Wednesday, January 27, 2010 1:41 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
HI,
how to check weather agent has the right to access the share folder permissions
Post #854722
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse