Transaction Log Backups Failing

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Transaction Log Backups Failing

Postby JoshDBGuy » Tue Apr 02, 2013 8:01 pm

Hello,

This morning I started running into T-Log backup issues. Here is the information,

1. T-Log backups were working fine until 5:00 AM this morning.
2. At that time I started receiving errors with the error message, "SQL error 17: SQL Server does not exist or access denied.
Failed to connect to SQL Server Instance."
3. Last backup was last night at 8:00, all completed successfully.

Here's what I have tied so far:

1. Restarted SQL Backup Agent - No Success after restart
2. Recreated the T-Log job - No Success after retry
3. Pinged the server from the redgate location - ping replied
4. Checked permissions and access of our redgate account to sql server - No Success, permissions are correct
5. Tried a one-off backup through Redgate of one database - Did not work
6. Checked all windows logs and sql server logs - No helpful info found
7. Did a one-off backup from within SQL Server using the SQL Server backup tool to the t-log backup location using the redgate account - This worked which means it's probably a Redgate issue.

Thanks All!
JoshDBGuy
 
Posts: 8
Joined: Fri Jan 04, 2013 7:00 pm

Postby JoshDBGuy » Tue Apr 02, 2013 8:40 pm

All,

I figured it out.

Thanks
JoshDBGuy
 
Posts: 8
Joined: Fri Jan 04, 2013 7:00 pm

Postby oderks » Wed Apr 03, 2013 9:13 am

Now I'm curious to the solution....
oderks
 
Posts: 46
Joined: Wed Jul 30, 2008 9:57 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests