.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Transaction log file size preventing all db transactions

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

Hi, my SQL Server 2008 db is suffering from the transactional log full error.

Can't detach or backup the dbase -- all result in the transaction log full error.

Can't rename the .ldf file, the ALTER statement errs out with  "MODIFY FILE failed. File 'vpa2_log' does not exist."

alter database vpa2 MODIFY FILE ( NAME = vpa2_log,

View Complete Post

More Related Resource Links

Transaction Log Backup & Transaction Log file size



Database is in Full Recovery Model.  Backup is done as follows

1)  Full Back up done every Sunday 00:00

2)  Differential Backup done Done Every Day at 00:00

3)  Transaction Log is Backed Up Every 15minutes.


I have a problem Transaction Log Size suddenly gone to 22GB (Data File is only 100mb) and Transaction Log Backup ruinning for a long time but it is not backing up. 


Why is this problem occuring?  How do I solve this? 


NTFS: Enhance Your Apps With File System Transactions


Presented here is an overview of Transactional NTFS and how it revolutionizes transactions.

Jason Olson

MSDN Magazine July 2007

Log file size question

I recently setup transaction log backups after we had a log file get near its capacity. I noticed after log files are truncated, they still use up the same amount of disk space. Is it safe to shrink a log file?  If so how do you determine what is an appropriate size to shrink it to? I ask this because some databases, like a sharepoint content database, have log files that are 130 GB in size when their data files are only 5 GB.  I assume that now that I am running hourly log backups they dont need logg files that huge. -Edit - Also most of the logg files are setup with the default settings

file size increase when moving from file system to sharepoint 2007

Hi, While moving files from file system to Sharepoint 2007 via windows explorer view, why do file sizes increase? thanks, Burcu  

How can I reduce the .sql file size?

The program in our office has program called eSRE. My Database server is called Wamp Server. In Wamp Server there is a MySql 5.0. MySql is my Database. Now, I already encode a lot of records in my database. When my computer encounter an error, I backed up my database and has named of lgusresystem.sql with 3,895KB. Now, after I reprogrammed my computer and reinstalled the said program, I imported such backed up database file (lgusresystem.sql) into a MySql Server but the computer prompt a message like this "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration". Here in MySql Server, I can see here that the maximum file to be imported is only 2,048KiB. So, what am I going to do so that I can restore my latest records in my database? I hope you will give an appropriate immediate action on this matter. Thank you very much.   JEFFREY R. DAWATON from Philippines  

Very high transaction log file growth in SQL server

Hi,   I am using with below version of SQL server. Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2).   One of my database transaction log file is getting full very frequently on PROD database,which i have truncated ones and shrunk ones after that i have taken full backup immediately.Again the Db tran log file grown to very big size. We are taking the transaction log backup for evry one hour. and The column shows log_reuse_wait=2 & log_reuse_wait_desc=LOG_BACKUP from sys.databases. Can you please suggest me free the transaction log space without truncating the log file.   Thanks, Gangadhar  

check file size before uploading process in c# with asp.net


Hi All,

Thank you for Advance.

currently we are configured execution Timeout="1200" (The default is 110 seconds)  and maxRequestLength="12288"  (The default is 4096 KB)

but some times users upload files above 12MB so we are getting "Maximum request length exceeded" error.

we are checking the file size using client side javascript ActiveXObject object. but ActiveXObject only works in IE not in others like mozilla,crome,...

Jacescript Code are

function GetSize(file)
  var fso=new ActiveXObject("Scripting.FileSystemObject");
  var f=fso.getFile(file);
  return fso.getFile(file).size;


how can i check the file size before uploading process with support all the browser.

any posiblities for checking file size before server side script/object?


Multiple databases backup/restore in a transaction, if possible, into only one file


Hi dear,

I have three databases named XDW, XOLTP, XOLTPSchema. All of these are for only one application. In the application, user should do backup/restore using GUI.


1. How I should do backup/restore in one transaction? i.e. all of three actions should be success elsewhere all of them should fail.

2. Is it possible to backup them into only one file e.g. X.bak?

3. Or, What is the standard solution in this condition?

Thanks in advance.

How To: Joining multiple DataTable using “LINQ to DataSet”

How can I shrink the size of LDF file after BACKUP LOG?


Ive just done BACKUP LOG against particular database and found no changes in size for the appropriate LDF file. It is shrunk only after I issue:







But this approach breaks all logs chain. Is there any way to shrink the LDF file for FULL backup model without destroying the whole sequece of log backups?

Does re-indexing job increase log file size?


I have a multi databases SQL instance with a total size of 886GB.

I ran a large delete records and drop tables script in a purging process, Then I ran shrink script on all databases.

The size went down to  517GB, Yet after running the re-indexing job it went up to 635GB.

Does re-indexing job increase log file size? or else what cause this size increase?

SharePoint 2010 Incoming Email cannot process file attachment with zero size.


When sending email with attachments to SharePoint list, if one of the file attached to the email is of size 0, then none of the files will be saved and NO new item will be created in the list.

The SPEmailHandler's ProcessAttachment method should check the length of the "contentStream". If the length is 0, it should return immediately.

As you can see in the ProcessAttachment method none of the arguments are validated before they are used. This an example of poor quality code.

It should do at least

if (contentStream == null || contentStream.Length == 0) return;

if (string.IsNullOrEmpty(fileName) || item == null) return;


private static void ProcessAttachment(Stream contentStream, 

Finding client file size before uploading


I need to upload images from client to server as follows:

1. Server is passing the client a file name
2. Client is checking file extensins to ensure it's an image then issues a __dopostback to the server.
3. Server uses the FileUpload control to save the image on the server.

I have that all covered, but, if image is too large, the upload fails with the following error: 'System.Web.HttpException: Maximum request length exceeded.'

Is there a way to check file size on the client (without the use of ActievX which also errors out), before it is passed back to the server?

Sample code will be greatly appreciated.

Issue with non-replicated transaction in Log file


Hi All,

I'm trying to shrink my Transaction log. Its taking 8 GB of space and I'm getting out of space on this drive. The database is in SIMPLE recovery model.

The problem is that when I see the log info using DBCC LogInfo() it shows 2723 rows with Status of 2. I issued the Checkpoint command many times as well. There are very few rows with Status 0 which are removed when I shrink the file. But these 2723 rows with Status of active-tran are taking up the most space and are not getting cleared.

I had restared the sql server service manytimes (just for experimenting). Eventually, I exectued the DBCC OPENTRANS command; which tells me that there is a non-distributed transaction in T.Log. This transaction is the very first transaction in T.Log file with Status 2 and Parity 128.

This server used to work as Publisher few months back. All the Subscriptions have been deleted and the relavant Distributor and Subscriber have been re-formatted and re-installed since then. Now when I try to drop the Local Publications from this local server it gives me error for relevant Distributor or Subscribor machines which do not exist any more.

How should I truncate this Log file and unmark this pending non-distributed transaction from T.Log.

Kindly help me out with this :(.

SSAS error log file size growing




We have a SSAS server 2005 running on a 64 bit server.

This server generates a error log file under D:\MSSQL\MSSQL.2\OLAP\Log\Error_Log.Log

This file is growing enormously. its current size is around 112 GB which is 5 times the size of the cube itself.

Is there any way we can control the size of this file by setting any max size property in the SSAS server.

any help would be highly appreciated.






Multiple tempdb file size


Hello there,

I am little bit confused about multiple tempdb files.

Suppose i want to place tempdb on its own disk of 100 gb, and want to set the size of tempdb to 100 gb. So in near future it probably do not need to autogrow. To impliment multiple tempdb file i.e. 8 (as per MS recommendation), because we have 4 quadra core processor that is total 16 processors. So how to set size for 8 tempdb file.

Pl provide detail with step.




Validation on file upload size


Hey all

I have an application that lets the use upload a pdf, I wanted to put a limit on the size the pdf can be. If the user tried to upload something too big I wanted to display a message to the user. I am trying to use a custom validator where it checks the size of the file and if it is too big it will set the "IsValid" to false. Is this the correct way to go about doing this? Is there a better way? When I test it, everything works in IE 8 and FF, but it does not work in IE 7 and can't figure out why.

Here is what I have so far, this is on my aspx page:

			<td>Upload Board Book PDF:</td>
			<td class="required">*</td>
			<td><asp:FileUpload runat="server" ID="PdfFileUpload" /></td>
                <asp:RequiredFieldValidator runat="server" ControlToValidate="PdfFileUpload" ErrorMessage="*PDF is required" Display="Dynamic" ForeColor="Red" ValidationGroup="add" /><br />
                <asp:CustomValidator ID="FileUploadCustomValidator" runat="server" ControlToValidate="PdfFileUpload" 
					OnServerValidate="FileUploadCustomValidator_ServerValidate" ErrorMessage="*File must be less then 20mb
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend