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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-06-28 : 00:09:35
|
| Dear All,We have scheduled the database backup through the Job agent,The job has been failing with the following error.MessageExecuted as user: . The transaction log for database 'yyy' 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.Please help me to identify the root cause for the issue.Thanks,Gangadhar |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2010-06-28 : 01:25:05
|
| Which type of backup u doing full or Tlog?Have u limited the transaction log size?RKNAIR |
 |
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2010-06-28 : 08:08:10
|
| Take a look at this.Ray MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL Image Viewer - retrieve, view, convert and export images directly from SQL Server, SQLite and Firebird databases.SQL Data Sets - share and distribute SQL Server and Oracle data sets securely and easily |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-06-28 : 08:33:51
|
| Do you take regular backups of the Transaction logs?, if not happen look into creating an additional job to take a backup of the transaction log. This should then stop this problem-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
|
|
|
|
Backup Issue