ALTER DATABASE [YOUR DB NAME]

SET MULTI_USER

WITH ROLLBACK IMMEDIATE

this works most of the times...

Thanks Master Gail..

As you said the transactions might have already been committed and VLFs have been marked as reusable thats why I was able to delete the newly added log...

Hi Master Gail... Like the way you educated on Log space, Can you give me a preferred Link to Study in depth on Resource Governor. There are a lot online...

Hi Master Gail. Thanks for quick reply.

I just found out that Resource Governor of all of out instances in the clusters are managed by WSRM. How can I know...

select name,max_cpu_percent,max_memory_percent from sys.dm_resource_governor_resource_pools

Max CPU Percentage settings in a SQL Server 2008 R2. How do I know what would be the optimal percentage to configure. Is there a way...

Strange I did not do any shrinkfile I just went to DB properties and removed the log file from there and the log file just vanished as if nothing was...

On a general note. In the article that you suggested, there is line where its says

undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN...

Thanks mahesh.. your query is a little more elaborative than mine.

But my main question is if the Initial size is 70 GB can the consumed be 3 mb? I have...

I just red the whole article. actually you have provided the same article in the other issue as well.... Anyways

I have created one more log file here gave 50 GB...

Hello Master Gail: Thanks a million for such beautiful article on log behavior.

Quick Question: I have seen a situation where the there is no replication setup on the DB ....

Thanks mahesh:

Lets say if the drive is full, what options do we have apart from growing the mount point capacity.

Or is there a way to match the LSN here?...

Can you be more descriptive on this.

DB Recovery mode:

Is Differential Backups been taken every while.

OR.. Do this

DBCC Shrinkfile(Adventureworks2012_Log, 512);

Yes I bet its the run away query. The log sizes are 90 and 85 GB. the data file sizes are. 1.4 TB and 900 GB.

the delta run job might...

The number of times index has been used in an update operation (this counts inserts, updates, and deletes) along with the time of the last update

Agree with Master Gail Or if you do not need the Logs Just drop the database and then attached the data files with no ldf file. That way a fresh...