Tag Archives: Transaction Log

The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

09-10-2012 I got this error today for one of my test databases. Following are the steps to solve this. Step 1 The error message gives a hint to look in the log_reuse_wait_desc column in sys.databases table. So we will just do it. This gave me following result for my database. name               log_reuse_wait_desc RP2_TEST    LOG_BACKUP IfContinue reading “The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases”

How to (Full and Transaction Log) backup and restore a database in Microsoft SQL Server 2005

2008-12-04 In this article I will discus how to backup a database as a FULL backup or with Transaction Log (Tail Log) backup and how to restore the database, how to recover transactions made after you taking the backup, etc. Since it is not easy to use and organize images in the post itself IContinue reading “How to (Full and Transaction Log) backup and restore a database in Microsoft SQL Server 2005”