.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

i am deleteing one table after i checked .mdf file size is increaged why its hapan ?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


   i deleted one r 2 tables in prod db , before of deleting tables, i checked size of .mdf is 37 gb and .ldf is 12 gb.

once deletion opetion completed , again i checked my files sizs now .mdf is 40 gb and .ldf is 19 gb

i don't know what happen here but my db priorities is

 1. my DB recovery model iss full

 2. i am taking full and diff backup daily evry 3 hrs diff backup and night full backup

 3.In drive aslo huge free space is there

4..mdf file auto growth is 1 mb and .ldf auto growth is 10%

5. every day full backup size is 36 gb

  Please help me any one...

 i am not able finding hw its incrage .MDF file size...

please suggest me hw can i delete table in future  in my db , tel me any procedure ? next aslo same .mdf file size is incraged mean i am cick off my bucket

Please adive me all blog viwers

View Complete Post

More Related Resource Links

Import XML File to SQL Table

Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.

First, the following XML is saved to XML file C:\Products.xml.

Can not perform this operation.The file is no longer checked out or has been deleted?

In my sharepoint designer 2007, when I try to check in a file, it give me the following errors:

Can not perform this operation.The file is no longer checked out or has been deleted.

Please advise me how to fix this problem?


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

"The file is not checked out" on page Postback

Hi there, I have a Publishing site with the Pages library set to "Require documents to be checked out".  As an administrator or member of the site, when i minimise/restore webparts on my page, then perform a postback operation (via some webpart on my page) i get an error saying:  The file is not checked out.  You must first check out this document before making changes. Its as if during the postback after minimising/restoring a webpart SharePoint wants to save that state! How do I stop this from happening?  Is there a personalization setting i am missing?   P.S. Here is a dummy postback operation if you'd like to test it, just paste it into a CEWP: <a id="Test" href="javascript:__doPostBack('Test','')">Test Postback</a>  

customize list view table header css file

i need to make table header for my list to be red and on hover to get specific  image so all my site have the same appearence also i need this to reflect to the list view webpart thanks

Upload millions of file records to a table

I have six input files having millions of record. I need to upload these data to my table. How can I upload the details in the most efficient way. Any help on this will be greatly appreciated.

How to calculate a SQL Server performance of a query based upon table schema, table size, and availa

Hi What is the best way to calculate (without actual access to a SQL Server) the processing speed of a query (self-inner-join) based upon table schema, table size, and hardware (CPU, RAM, Drives)? ThanksThanks Jeff in Seattle

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 to fix the height of the table to be same as the screen size?

hi,iam trying to have my web page design inside a table that fills the screen in width and height.i tried like this<table  border="0" cellspacing="0" cellpadding="0"                         style="width:100%; height:100%; margin-right: 0px; margin-left:0;margin-top:0; margin-bottom: 0px;">            <tr> etc...the table width is filling 100 % but the height is not expanding to the bottom of the screen.my aim is to have a column in the table that looks like a left pane and it will contains dynamically added controls so if there is controls or no the column will have the height of the screenthanks for the help

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  

How can we insert csv file data into Sql server table based on some condition ?


Hello All experts there,


I need to insert some csv file data into sql server 2008. but there are multiple tables created in sql server and I need to check some conditions before data insertion and based on the condition value, sql script should insert the data in to specific table. in other words I need to insert data from one csv file to different tables based on some condition.

is it possible? if yes then can anyone please give me an idea on how can we do that?


Thanks in advance


Nipendra Garg

update a single table in edmx file


I'm working on the big project who has edmx file with lots of table. I want to update a table from DB. But when I update the edmx file, it  also refresh the other tables from DB. How do I update single table?

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?


Arrange columns from nested table in a dataset that writes into XML file



I have 3 related data tables. I added these tables into a dataset and finally write it to a XML file. But the related columns from table 2 and 3 is appended after all the columns from table 1. How can I have something like:
in a dataset that I write to XML instead of

Can i upload file to database table using AsyncFileUpload ?



can i upload my pdf or word file to oracle/SqlServer database table ?

How ? 

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?

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