SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Backup Log is terminating abnormally.		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pbraden
Starting Member

USA
1 Posts
Posted - 09/21/2005 :  13:29:19  Show Profile  Visit pbraden's Homepage
We continue to get the following error when backing up a particular transaction log. All of the other database logs within the Job back up fine.
Any ideas?


Database NetTracker: Transaction Log Backup...
Destination: [\\YANKEE\SQLBACKUP\NetTracker_tlog_200509211200.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on '\\YANKEE\SQLBACKUP\NetTracker_tlog_200509211200.TRN' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 09/21/2005 :  13:36:48  Show Profile  Visit tkizer's Homepage
What happens if you run the same command in Query Analyzer?

Tara
Go to Top of Page

MuadDBA
Aged Yak Warrior

USA
623 Posts
Posted - 09/21/2005 :  15:48:42  Show Profile
uh, it says see the SQL error log for more details....did you check that? Usually it will give a little, tiny bit more ifo about the error.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000