Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Cannot Update permissions on folder
Last Post 07/02/2013 10:23 PM by Rob Ralston. 3 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
BartS
New Member
New Member
Posts:12


--
07/02/2013 8:07 PM
Hi
I'm trying to update the permissions to a parent folder and unify them on the sub folders but I am getting the following error:

A critical error has occurred. The transaction log for database 'RDP' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

The log_reuse_wait_desc column in sys.databases says 'ACTIVE_TRANSACTION'.

Any ideas as to why this happens?
Rob Ralston
Basic Member
Basic Member
Posts:164


--
07/02/2013 8:27 PM
Hi Bart,

It sounds like the database transaction log file is full, just like the error says. That would likely be because the dB is in full recovery mode and no transaction log backups have been made. Tlog backup have to be made to truncate the transaction log file. Simply backing up the dB does not do that.

It is likely that the log file is huge and the disk may have run out of space.

Rob Ralston
BartS
New Member
New Member
Posts:12


--
07/02/2013 10:07 PM
Thanks for your reply Rob.

My database is in a SIMPLE recovery mode so it does not have logs.
Rob Ralston
Basic Member
Basic Member
Posts:164


--
07/02/2013 10:23 PM
Even in simple recovery mode there is a log file, and the physical file can grow quite large depending on what a database is doing. It is automatically truncated "on checkpoint", but that is a logical operation, not physical.

So check the disk with the log file, and the size of the file, just to be certain. If that is all OK, then it looks like you may be experiencing a database problem, possibly due to the number of files and folder being "unified" and the resultant number of transactions.

Rob
You are not authorized to post a reply.