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

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

Large transaction log files after backups

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
I have noticed that the size of the transaction logs on my databases have rocketed lately, I do have full and differential backups in place for the databases in question, any reason for the sudden increase in size and is there anything that I can do to mitigate it. Some of the databases have a simple recovery model on, in which case transaction logs shouldn't be maintained, but I note that the sizes are still huge and this only started when I began taking full backups and differentials. Thanks.

View Complete Post

More Related Resource Links

Document Conversion of large files



My MOSS 2007 environment fires OutOfMemory exceptions when attempt to launch a custom Document Converter on files larger then 50 MB (Video files) . Because my Document Converter is implemented by a standalone executable, I'm figuring these exceptions are fired by Sharepoint Work process, on downloading/uploading from/to temp folder, not by my custom converter.

If this is the case, can I apply any workarounds on server configuration ? I tried with /3GB switch without luck. Maybe SP1 will address this issue too ?



How to manage large .trc files?

Hello everbody,        Sir, with raid 10  with enough arrays to hold files saperately.    Is an array of raid 10 will be identified as one logical drive? such as c:, d: e.t.c.   Actually I want to store trace files on server to capture representative workload for DB Tuning with DTA. As i know that will be very large in size as my OLTP DB gets very busy at 8 a.m. to 7 p.m. and less busy at diff. time and i don't want any event to be missed out due to lack of resources. So how to manage this?   Can i attach ext. HD to the dedicated sql server to hold .trc files? Is it advisable?   Pl provide any available link for config. best practices for raid 10. Or standard config. for raid 10 to get optimum performance. Or any suggestion regarding this issue.   Thanks in advance  

Server generate frequently large mdmp files

Hi, I have running MS SQL Server 2005. Server generate frequently large mdmp files which took c: drive space. kindly tell how i stop creating these and keep the c: drive space. thx iffi

Storing large files (10gb) in MOSS.

Hello, We are planning to develop a portal with few lists in the portal. We have a requirement to store huge files of approximately 10GB in size. Can any one let me know If we can have a mechanism where in we can only save the file meta data to a MOSS list and save the actual file to a file share (Data Center)? I am looking forward to a generic service(WCF) which can perform this functionlity. If it is possible can some one provide a series of steps to achieve this. Thanks,kesari suresh

What is the best Hosting model when Uploading Large Files via WCF?

I am building a WCF service where besides regular CRUD operations, it porovides methods to upload large (upto 15MB each) files. The service will serve a number of "clients" that will send data to our back-end. Now, while some of the clients are ok with sending one file at time, others would like to be sending these files in batches (i.e. several files at a time).... My questions: What is the best option for hosting this service considering the environment (see below)?  Will IIS be able to support it or will it time out? I know you can increase timeout limit in config file but how will it handle a batch of large files at a time? Is windows service a better option here? What are the dis/advantages of IIS vs Win Srvc in this scenario?  Current Environment: Win 2003 Server w/IIS 6.0 and WCF (.NET 3.5) Thanks in advance!

Upload large files from a web page

I am trying to figure out a solution to upload large files under a web page. I know WCF + Streaming is a proper solution for large file transfers, but I am not sure how to get the WCF client implemented under ASP.NET. Here is the link: http://mark-csharp.blogspot.com/2009/01/wcf-file-transfer-streaming-chunking.html Please advice if you have any solution.   Besides, is there anyway I could implement a progress bar showing the upload progress while the file is being uploaded, and voiding page timeout?

Upload large files


Hi all,

What is better way to large upload file.

using a web service or in application itself.

If in application, how can we check that files is to upload.

actually i dont want user to wait for complete uploading, when it starts uploading user will get response of uploaded and uploading will be done  in backgroud.

I am not sure this type of task can be done in webservice also so that user doesnot need to wait for complete uploading.

and one more query which event fires when the page redirects to another page.

Is it Page_UnLoad or Dispose

Any suggestions is appreciated.

How to avoid the memory exhausion for handling large Image files in C# ?


I have been developing a Form application for handling a large number Image files. The number of Image files could be more than 1,000 and each Image size is about 2MB. The code is as follows:

PictureBox[] pb = new PictureBox[iPictureBoxNumMax];
Label[] lb = new Label[iPictureBoxNumMax];

for (int i = 0; i < iPictureBoxNum; i++)
    lb[i] = new Label();
    pb[i] = new PictureBox();
    pb[i].ImageLocation = @sImageListAll[i];


for (int i = 0; i < iPictureBoxNum; i++)

(1) If the number of Image files is less than 300, the PictureBox generation code (the 1st portion) works. If the number is larger than that, an error message of "Memory exhausion" is displayed.

(2) However, the second protion of the code (pb[i].Dispose()) doesn't seem to clear, since the re-run of the first portion gives an error message of "Memory exhausion".

What should I do ?


XP x64 issue with large tiff files


I've got some code which opens and processes a large tiff file (a bit over 2GB with around 1000 frames in).

This works fine on Windows 7 x64 but fails with an overflow error on XP x64.

Other software (including the windows image browser) has no such problem.

Is there something I can do to make my WPF code cope with larger files in XP x64?

 using (Stream instream = new FileStream(sourcePath, FileMode.Open, FileAccess.Read, FileShare.Read))
  TiffBitmapDecoder tiffInDecoder = new TiffBitmapDecoder(instream, BitmapCreateOptions.PreservePixelFormat, BitmapCacheOption.None);


Iain Downs

Large files over httphandler and IIS7 or of memory



I have a problem with large respones and IIS7, the server runs out of memory.

I've written the test code below that works pretty much like my real code... When i start to download the file i can se the memory usage rise until it hits 100% and Firefox complaints about lost connection to server, looks like IIS7 does not release cache or something.. Works in IIS6 by the way...

Thanks in advance, Anders

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Threading;

namespace HttpHandlerTest
    public class FileHandler : IHttpHandler
        public bool IsReusable
            get { return true; }

        public void ProcessRequest(HttpContext context)
            int buffSize = 8192;
            int itterations = 1024 * 500;

Large files, using FileUpload in Sharepoint


Hello All.

We have a problem with some people working from home where when uploading 30-40mb (max upload is 50mb) they are timing out.

Naturally when these people are on site they have no problems because of the network speed with have.

What are peoples thoughts about extening the time out period, working on an 250k upload speed from home, we would be thinking about 20 to 30 mins.

Please discuss all aspects of this, we are in a real quandry.



Uploading Large files via Web Service | HTTP Error 413 - Request Entity Too Large.


Hello all -

I am trying to implement a Web Service, which accepts a binary file as a byte array for one of its parameters.  It's workings are based on this article:

Anyhow, the size of the file can be significant as the types of files being uploaded through the service are MP4 Video files.  The service works on my WinXP SP2 localhost, but when I implement it onto a 2003 Server and try to consume the service, I get the following error back from the web service:
The request failed with HTTP status 413: Request Entity Too Large.

I do a little searching around and find a few articles indicating that I need to adjust my "MaxReadAheadLength" property in IIS.  A good example of one of those articles is here:

The suggestion from the article is to execute the following command on the web server:
cscript adsutil.vbs set w3svc/1/uploadreadaheadsize 204800 

FYI, the adsutil.vbs is in your IIS's AdminScripts directory.  I'm guessing that the /1/ part of the command is th

How to go around the file size issue when uploading large files?



In my application the user uploads three files ( Resume, Cover Letter, Selection Creteria).

I want users not to upload more then 4 MB files, so In my web.confing file I have allowed max of 5 MB. <httpRuntime maxRequestLength="5000"/>. I did this so that I can validate the file and give user a message that they are trying to upload more then 4 MB file.

It all works fine if the user is only uploading resume. But if the user uploads all three files of size 4MB then my validation does not work and it goes to connection time out.

How can i handle the validation to check the file size of all 3 files?


Reading large binary files



I currently have a WPF app that controls a printer. The app reads very large binary files (bitmap images, larger than 1 GB) and does some bit manupilation on them.

I am currently using a FileStream to read 100MB worth of bytes into a buffer (using FileStream.Read method). After that I start my method that does the bit manupilation on the image file and sends it out to the interface on a printer. When the buffer nears the end of the 100 MB length, say when there are few 100 bytes left to read in the buffer, I call the FileStream.Read method again to read in the next 100MB worth of data from the binary file. I specify the offset to read the binary file by using FileStream.Position method.

The problem I am facing is that when it finishes reading the 100MB buffer and goes to read the next 100MB worth of data, the printer pauses for the amount of time it takes to read the next 100MB and after that there is a pause for every line it prints in the image. It is like .NET framework or the compiler looses sync of doing things a particular because I have to read the next 100MB and then never recovers. The pause is about 2-3 seconds.

Everything is working great, the bit manipulation is correct, it reads the file correctly, the printer prints the file the way it is supposed to, except I want to avoid the pause.

Any suggestions....Can I use a back

Unable to upload large files



I am unable to upload even 75MB file ... it seems MS for some good sake is putting a limit of the file.

Please suggest how can I overcome this issue

Thank you




Issue with infopath and large attached files (over 27MB)



I have an annoucement list, which  has been customized in infopath ("customize Form" button). Nothing funcy, just adding some comments.

The form opens , and I attach a file, over 27 MB (22 MB works with no problem).

I press save (wait for 20 secs) and and error occurs:"Error processing the form"

I press retry, a popup window appears saying: "sending data to the server" and then an error window appears:


A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact your server farm administrator. 

Click Start Over to load a new copy of the form. If this error persists, contact the support team for the Web site.

Click Close to exit this message. Correlation ID:cdb26c5b-ea08-4bb9-8525-34d9b16a30c8

I open the logs and copied-pasted here:


11/04/2010 10:39:58.28 OWSTIMER.EXE (0x0FFC)                   0x130C

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