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 2005 Forums
 SQL Server Administration (2005)
 transaction log

Author  Topic 

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-03-17 : 02:00:37
hi,
i am getting the exception like
" Back up the transaction log for the database to free up some log space" in sql server 2005 giving The log file for database 'ezEMRx_6_24' is full.how to overcome it.
but i have cheked in database properties it is ok like in files both mdf and ldf are given as with auto growth command by 10% increase unrestricted growth.and in my hdd there is sufficient amount of space.
can anyone help me out in this scenario what exactly i have to perform?

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-03-18 : 11:16:34
Take database log backup.
Go to Top of Page
   

- Advertisement -