July 6, 2010 at 11:46 pm
Dear All,
One of my scheduled backup job is failing i am not pretty sure why exactly its happening I am hereby enclosing the Error log if some body have faced similar issue pls do help me.
Date4/07/2010 5:00:01 AM
LogJob History (Backup EE)
Step ID2
ServerJJJJJJAYAA
Job NameBackup power
Step NameBackup EE- Differential
Duration00:00:00
Sql Severity17
Sql Message ID3013
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: AP\ytrr. The transaction log for database 'Power' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases [SQLSTATE 42000] (Error 9002) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Your help in this regard highly appreciated.
July 7, 2010 at 1:15 am
Gangadhara MS (7/6/2010)
Executed as user: AP\sys_power. The transaction log for database 'Power' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases [SQLSTATE 42000] (Error 9002) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.[/color]
Check if you have insufficient disk space, Tlog is full to allocate more space depending on the growth rate it is not finding enough space to expand. Free the disk space, take the backup and move the tlog to the disk where there is plenty of space.
Also find out why the tlog is growing?
check MS KB on this :
http://support.microsoft.com/kb/317375
"More Green More Oxygen !! Plant a tree today"
July 7, 2010 at 6:33 am
Sounds like the database might be in FULL recovery mode but you don't have log backups running, or possibly, the log backups are not running frequently enough.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply