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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Backup Log is terminating abnormally.

Author  Topic 

pbraden
Starting Member

1 Post

Posted - 2005-09-21 : 13:29:19
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

38200 Posts

Posted - 2005-09-21 : 13:36:48
What happens if you run the same command in Query Analyzer?

Tara
Go to Top of Page

MuadDBA

628 Posts

Posted - 2005-09-21 : 15:48:42
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
   

- Advertisement -