SQL Server :: Changing Growth And File Size Of SQL Database Files?
Aug 2, 2010
When I initially created my SQL Express 2008 database I vastly over-estimated the size of my database files. The problem is that now I have the correct field sizes and data actually in the database it does not require the max file sizes and growth that I had originally set.
This is a problem as I have a max database size of 500Mb with my web hosting provider and it appears that my database now has too large a footprint. This is after I have used the shrink database command in SQL Server Management and shrunk the database to a size of 6Mb so I can only presume that the problem lies with the fact that my original file size / growth settings are taking my database size to well over the 500Mb threshold I am permitted.
Is there anyway for me to change the max file size and growth options of my database without having to recreate the database from scratch?
I manage a large asp.net site which has previously been converted from static html site to asp.net. For several reasons (mainly SEO) we decided not to rename all the files to .aspx back when we originally converted the site. This was very easy to do by simply adding the buildProvider and httpHandler to the web.config.
Now I am upgrading the site to use Asp.net WebPages with Razor cshtml files. I can rename all the files if necessary, and use url rewriting to make the urls stay the same, however it would be much easier if I could just configure the web.config to tell it to parse .html files as if they were .cshtml. I have searched around quite a bit, and could not find anything equivalent to the PageHandlerFactory for razor pages. It appears as though it is just an internal mechanism in the .net 4.0 ISAPI handler.
The site is currently running on Windows 2003 server and IIS 6. We will be upgrading to 2008/IIS 7.5 in the near future, but I'd prefer not to wait for that. Is there any way to get the .html files to be parsed by razor as if they were .cshtml files?
I know the content palcehlder does not have a size ,I have a masterpage and content page, the master page has a table with a header, content area, and footer, header and footer are fixed size, content area is 100%. As the user sizes the browser the content area grows and shrinks and the footer stays at the bottom of the browser window - perfect!
Problem: The contentpalceholder does not grow to fill the available content area. Now, the contentplaceholder gets its size from its contents, which in this case is a div holding a silverlight object.I was thinking I could hook the master or child page's re-size event and somehow pass that info onto the SL object, but as it turns out (and I'm surprised I never knew this) there is no aps.net page re-size event! (really?, wow.)
So is there a way to get a SL object hosted on a master page to size itself based on the size of the browser window?Or more generally, a way to size the contents (like a div or panel) of a contentplaceholder based on the browser? on a standard aspx page (not a master page) I CAN get the SL object to size itself based on the broswer, the problem seems to come from the fact that I'm hosting the SL object in a content placeholder.
I guess I could 'unroll' the master page into several standalone pages and have it work, but the menu is on the master page and I'm used to using them, plus it's already done...<sigh>
I am using TabContainer with some controls on each tab (asp: labels, text boxes). When redirecting to the page that contains the TabContainer, the tabs and their content loads as expected, but when there is a postback, and the page refreshes, the TabContainer UI changes - the font size of the labels gets bigger, the text boxes become bigger and their location changes a bit (not aligned as before), and the tab header is partially hidden. I am using IE7.
I dont know if this is relevant but in some of the text boxes i use edit mask extender as well for date. Also, I have used a table inside the TabContainer for layouting the controls.
I have a .swf file embedded in my asp.net webpage. It is slow to load although the size of the file is 1.60 mb. What might be the reason for the slowness? Is there a way I can speed it up in asp.net?
I know this is a bit like how long is a piece of string question, but I'm wondering how big some peoples ASP.NET Temporary Files folder, gets. I wish to move this folder to a RAM DISK so I'm trying to see how big this should be set, to.
I'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
My requirement is to get the file size in client side. there is no problem in FF but in IE you can't do that unless u r using an activeX object. So we thought of putting it in browser cache and reading the file size from there and when we post it to the server we will be taking it from the cache and send it to the server.
When the user selects the list of files from a page and hit's download selected, then a post back happens to server and starts zipping on the server. This works great until we hit the timeout on the page ( which is default to 90 seconds ) and just returns the process to the page even though the backend process is still zipping. Is it possible to show the size of zip file when the file is being zipped instead of waiting till the end to provide the download link?
With the ajax file uploader, would it be possible to check the size of the image before uploading?Currently, it uploads the file to the server and then lets me know that it's bigger than the limit size.
the file is being saved on the server & needs to be same on the local system too so used the above code but the actual size is nt being saved on the local system if the file size on server is 3 MB in local system i gets saved in kbs
I'm developing an ASP.NET MVC3 application using the new Razor view engine but I'm having some difficulty changing a TextBox so that it is multiline. So far all I've been able to find via google is that I need to set the multiline property to true, but I'm not sure how.
I am getting following error ...when trying to do any operation....
"The transaction log for database 'MyDatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases"
I tried to shirnk file log file using ...
dbcc shrinkfile(EMRSET_log,1) But still same issue....And its show ...
We have a database with around 5000 records in it. We also have a web page that displays many of the fields. One field is an nText field and displays up to several paragraphs. My customer wants me to add those A+ and A- buttons for increasing and decreasing the font size for this field. My problem is that many of the older records have quite a bit of formatting in the field. Most of the rest contain styles dictating a font size of 12 px. Is there a way to increase and decrease the font soze of the text without modifying all the records?
in my project i would like to save pdf files in database, how to save pdf files in database ? along with that i would like to create create a search page to search for pdf files with PDF file names , how to accoplish these things
I have a requirement like need to get the numbers from diffrent tables and calculate the growth rate using the formula like ((number2-number1)/number1)*100 and bind it to gridview. Right now I am getting the numbers from each table, calculating growth rate @code behind and save the result into temp table and next getting the result from temp table and bind it to gridview. this is very lengthy process and low performanance.
How to do growth rate on the fly and bind it to gridview. Finally the gridview data should be growth rate desc order.
when a user enters edit mode of my gridview, the girdview becomes huge. How can I make it so my gridview stays relatively close to the size it is when it is not in gridview?
Have a question about the best approach for file storage in a SQL database. I have a table called Widgets, and each row in the Widgets table can have multiple files. I also have another table called Extensions, and again each record in this table can have many files.
Here is what I am considering:
Approach #1:
[Code]....
That approach is very simple and easy to use, but I feel that I could merge the two file tables into one, then use lookup tables:
Approach #2:
[Code]....
The thing is, there are no duplicate or shared files between the two types of objects. So even though I feel better about approach #2, I am concerned that I may be adding additional complexity (and using more server resources to perform the joins), than needed.
I want to save three images path in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....
I need to connect to 3 remote databases from my local machine and restore 3 .bak files, one for each database.I am new to asp and sql server and am finding SQL Server Management studio quite confusing. I cannot find any options to connect remotely or restore a database from .bak.
