Transaction Log Backup Failed (SE)

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Transaction Log Backup Failed (SE)

Author

Topic

elayaraja_apd
Starting Member

9 Posts

Posted - 2009-03-06 : 06:08:14

Hi,

I have found some error messages

BACKUP failed to complete the command BACKUP LOG [DBName] TO DISK = N'D:\mssql\Backup\DBName_Log_200704120400.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Source Spid 91
Downgrading backup buffers from 960K to 64K

Source Spid 107
Error: 515, Severity: 16, State: 2

Windows Application Event Log Entry:

Event ID:17055
3041 :
BACKUP failed to complete the command BACKUP LOG [DBname] TO DISK = N'D:\MSSQL\Backup\DBName _tlog_200704130800.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Drive Space - 90 GB

Need some helps to resolve this issue permanatly

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-03-06 : 09:14:31

Post full message from SQL Server Logs or Jobs? what is recovery model of your database?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources