Post New Web Links

WSS 3 Storage Space vs. Database File Size

Posted By: Posted Date: May 22, 2011 Points: 0 Category :C#

Our SharePoint (WSS 3.0) databases are on a SQL-2000 server that's starting to get low on disk space. In order to buy some time to move content into either our MOSS or SP-2010 environment we did some cleanup in SharePoint by archiving & removing several old sites and removing older document versions in a couple of libraries. These changes were made 3 days ago. The Site Settings | Storage Space Allocation page indicates that content size is a little under 37 GB, down from a bit more than 40 GB. (I did make sure that the deleted files / versions were also removed from the site collection recycle bin.)

What has us puzzled is that the physical database file on the SQL Server has not gotten smaller and the amount of "free space" that can be reclaimed has actually gone down - it's currently at about 200 MB. The database file size is over 57 GB; 20 GB larger than SharePoint reports.

So, I have a few questions:

Is it normal for the content database file size to be significantly (50-60%) larger than the amount of content that SharePoint reports?
Is it normal for the database not to get smaller (or at least have more internal free space) when a large amount of content is removed?
Is there any way that we can recover some of this space to get some breathing room on the SQL Server?

Thanks!

Mike:o

View Complete Post

More Related Resource Links

Restore database from system dbs and log file when .mdf file size set to 0KB after Windows Update ?

This can't be right. Friday I tried to install some Windows updates including ‘Security Update for …Windows Server 2008 for x64-based Systems (KB2416473)’ on both my host Server 2008 box and on a VM instance of Server 2008 running on the same physical box. An important SQL Server 2008 instance lives on that VM.

The above mentioned update failed on both the host and the VM, but a system shutdown and reboot were required for both OS’s anyway. When SQL Server started up again on the VM, the *.MDF file size for 2 (out of maybe 15 total) databases had been reduced to 0KB. Additionally, 1 of accompanying *.LDF files was now also 0KB in size, while the other *.LDF file was probably its normal size of 2.9GB. All the other databases and log files, including Master.mdf, seem to be okay.

I’m new to SQL Server and have a couple of questions of cours

T-SQL for database size and space available (like on Database Properties page on SQL 2008 SSMS)

How can i (using T-SQL) get the database size and free space like the database properties page of SQL 2008 SSMS shows? I want to be able to display that information in our software.

thanks.

The file-size of website project contain blank database.mdf

I tested the file-size of my new website using VS 2008. The new website contains almost one blank page aspx and one “Database.mdf” with no record in database. “Database.mdf” contains one table, and the table has 2 columns with no record at all.

When I take a look the file-size of this website, total folder project size is 2.68 MB. The most file-size is at folder “App_Data” that is 2.67 MB. The breakdown file-size of “App_Data” is 2.2 MB for Database and 0.5 MB for Database_log. My questions are:

How much the file-size normally for the new website that is similar with my testing?
If there is something problem with my VS 2008 setup, please advise me how to fix it.

Thanks.

Does this look correct for saving a file/ new record to a database

So thank you for all your help so far, So I think i got this right,
but would like for you all to look it over to see if there is any
areas I might run into trouble with:

//using asp.net mvc 2
the table (sql server 2005, using entities framework)
"Pattern_Media"
table fields
"Pattern_Media_GUID uniqueid
"Pattern_GUID uniqueid
"Media varbinary(max)
"height int
"Width int
"Media_Type String (50)

the form:
<h2> Add Media to this pattern</h2>
<% Html.EnableClientValidation(); %>
<% Html.BeginForm("AddMedia", "Pattern", new { id= Model.Pattern_Guid} , FormMethod.Post, new {enctype = "multipart/form-data"}); %>

    <%: Html.Label("height") %>
    <%: Html.TextBox("height") %>

<%: Html.Label("width") %>
<%: Html.TextBox("width") %>

    <%: Html.Label("Media") %>
    <input type="file" id="Media" name="Media" />

    <input type="submit" name=

Need Oracle Data Provider .CS File for Oracle 10g Database connection !

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !

Bitmap FromFile space "file not found"

I am using aspose.slides to create PPTx's. Some of the process involves loading jpg's from another server and including them in the presentation. This works fine in my development environment. When I upload the site to its server, the jpg loading fails.

I am trying to access jpg's on the other server by:

oFS = New FileStream(sFile, FileMode.Open, FileAccess.Read)

This causes an access violation error when run from the server.

I also boiled the code down to reading the file directly:

oImg = System.Drawing.Bitmap.FromFile(sFilePath)

This causes a file not found error.

We have narrowed the problem down to the fact that the File Path has a space in it. How does one solve this problem (while still keeping the space, there is a lot of legacy data)? I have tried replacing the space with %20 or +. I have tried using Server.UrlEncode. The error message always comes back with the encoding in place (like no decoding

Data Points: Windows Azure Table Storage - Not Your Father's Database

Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

Julie Lerman

MSDN Magazine July 2010

Code Name WinFS: Revolutionary File Storage System Lets Users Search and Manage Files Based on Conte

One of the monumental problems organizations face today is aggregating information that's stored in disparate formats. Knowledge workers have long wanted to be able to search for content independent of format. The next version of the Windows operating system, code-named "Longhorn," boasts a new storage subsystem that makes that task easier. That subsystem, code-named "WinFS," allows the user to perform searches based on the metadata of the stored item, regardless of what type of file it is or which application created it. This article covers the basic architecture of WinFS and explains how to use the WinFS managed API.

Richard Grimes

MSDN Magazine January 2004

Web Q&A: Displaying Processing Messages, Accessing File Size and Bandwidth, and Debugging ASP

Robert Hess

MSDN Magazine May 2000

An example of packaging web application containing database upgrade SQL file

A few months ago, we have a blog talking about extending the web publishing pipeline to package database project deployed SQL file. In this blog, I'll show step by step example of packaging web application with SQL Server database upgrade SQL file using Visual Studio 2010. This way, we can generate a web package with incremental SQL script to certain database version. The scenario may help distributions of a web upgrade package which needs to be installed on many different locations, each with their own SQL server database. 1. Create a Web Application Project 2. Add a new "SQL Server 2008 Database Project" to the solution 3. Prepare a development database, such as my test1 database as the following: 4. Right click our...(read more)

VS2010 Express ASP.net and database file with SQL Authentication

Hi,

I have installed Visual Studio 2010 Express in my local system.

Steps
1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio. I am only using the one which is packaged in VisualStudio 2010 SQLClient.

Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.

Thanks and regards
Mahesh kotekar
http://mahesh.kotekar.com

VS2010 Express ASP.net and database file with SQL Authentication - How to create database file with

Hi, I have installed Visual Studio 2010 Express in my local system.

Steps 1. File->New Website

2.Open datbase explorer, right click on dataconnection

3.Select Create new connection

4.use Microsoft SQL Server Database file

5. Type new databse filename

6. Now i want to use SQL authentication which is not working

7.If we use windows authentication its wokring without any problem

8.But i need sql authentication to be used.

9.I have not installed SQL studio.

I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication. I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc

i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components

Thanks and regards

Mahesh kotekar

http://mahesh.kotekar.com

Update Profile Database from text file using BDC

Hi,

I have a requirement to import the profile properties from a text file in sFTP to update the MOSS Profile Database. The objective is to create a single repository for the Staff Directory in MOSS.

Can I use BDC to connect and update the Profile database?

What is the alternate approach?

Regards
Sanra

Insert Excel Data via File Upload into sql server database???

Hi all, I have requirement that User can Upload the Excel Sheet Data to sql server Database at once. How i do that Any Article or hint is apperciated. Regards

XML size cost to a database

I am in the process of integrating a procedure that imports data into an xml format. The question I have what is the cost on disk versus just importing each colunm. Say I have 10 columns of data, how much more space does an xml column take than just 10 individual columns with the same data. I have searched everywhere and I can not find a definite answer that addresses this question. Any help is greaty appreciated.

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

Can't restore database backup file in my database ? using sql server 2005. please help

VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot: PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All