.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

Drives used for SQL databases are running out of free space

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint


I got the following error in my Health Analyzer, and have not been able to solve it, yet:

Drives used for SQL databases are running out of free space

The following databases have one or more files that may exceed the available free drive space. If this happens, operations will start to fail.

WSS_Logging on SQLC02\APP

Examine the drives containing the specified databases' log and data files.  Free space on these drives or move the database files to another drive.  A drive should have enough free space for the largest database file on it to autogrow twice. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=163560".

My database file is 7GB and the log file is 50MB. My database drive is 100GB and my log drive is 50GB.

Any suggestions how to solve this?


Best regards,


View Complete Post

More Related Resource Links

Help......Drives are at risk of running out of free space?



Drives are at risk of running out of free space.






The following drives on the failing servers have less than 5*RAM of GB free drive space:  (D:\),  (E:\).


Examine the failing servers and delete old logs or free space on the drives. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142688".

Failing Servers

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create th

I received the following error...*****System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 2739929088 additional free bytes, while only 801185792 bytes are available. (Microsoft.SqlServer.Smo)*****I have looked at the solution recommended on this forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79848 but I am still baffled as to why it says that I don't have enough disk space?  I ran the RESTORE FILELISTONLY command and it told me that the "size" was 1.4 GB and I've got 60GB left. I am starting to resolve that my .BAK is corrupt.  Are there any other reasons as to why I am unable to restore my backup?Thanks for any help in advance!

Running a single SQL update query on multiple foxpro databases

Hi, Env : SSIS 2008 My requirement is to run a update SQL statement on multiple foxpro databases. The fox database paths are available in a SQL server table.  I've created a for each loop control and assigned the database path to a variable named dbpath. Within the loop, I added an "execute sql task" control. Now what properties are to be set to get the requirement done. Appreciate any help. Regards. BH  Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Moving Databases between Drives

I have Sharepoint WSSv3 running and configured as a farm, using SQL 2008 Express on the same server and wondered what steps i would need in order to move the database from the C:\ to the E:\ (on the same server). I have been told in a previous thread to detatch the db and move the files and reattach the db, but then someone replied Don't forget to change the default paths so the subsequents DBs are created on E:?? What Default Paths?? what i was going to do is: Stop all sharepoint and sql services detach the db move all databases onto the E:\ reattach the db restart the sharepoint and sql services Is this correct??

Databases running in compatibility range, upgrade recommended.

I am running Windows Server 2008 R2 and Sharepoint foundation 2010. Both the server install and sharepoint are new and I don't understad why I am getting the the following notification in my Sharepoint Central Administration Console: The SharePoint Health Analyzer has detected some critical issues that require your attention. View these issues. When i clicked view issues two issues which are as follows: 1.   Title Databases running in compatibility range, upgrade recommended. Severity 2 - Warning Category Configuration Explanation The following databases have versions that are older than the current SharePoint software, but are within the backwards compatible range: SharePoint_Config_53245559-f688-46f8-9c1e-e6a5553fd80b, SharePoint_AdminContent_bdba18ef-0884-4062-ad0e-0e3674b9d814, WSS_Content, WSS_Logging. Remedy To achieve optimal results from these databases, use Upgrade-SPContentDatabase to upgrade Content databases, or psconfig.exe to upgrade other databases.  For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142697". Failing Servers   Failing Services SPTimerService (SPTimerV4) Rule Settings View The problem is when i go to the links under the Remedy headings they are both not providing me with any clear solutions. For the first pro

Do I need free space when doing full database restore in SQL Server 2005?


I have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.

The restore fails. Is it because a full restore needs  free disk space of 60G in this case?


Running Dbcc CheckDB on Production Server databases.


Hi Guys 

I am new to SQL Server Administration. I have set up the Backup jobs according to the requirements from the Application team. Also I have set tip the  update stats, Reindexing Job every 2 weeks as far as the maintenance as maintenance is concerned. I am using  SQL Scripts in the SQL Agent to perform all these jobs

But i have not scheduled any Integrity Check (CheckDB ) Jobs on any of the database in any of the servers. I have databases of Size 1Gb-50 GB and few from 100-600 Gb. 

I want to set up the integrity jobs on all the databases. Can you please suggest me some best ways how I can schedule jobs every 2 or 3 weeks on small databases and on big databases like 100 - 600 GB in SQL Server 2005,2008. 




log 32GB ,0 free space



I have db on sql2005 with full recovery and job to backup log every 1 hr

Currently  db trn log size 32GB with 0 bytes free

1. tran log backup created every 1 hr with size  of 1-10 MB

2. the is no open transaction in acitvity monitor

what is possible reason for log file taking some much space , in profler I don't see any insert/update/ delete operation


Thank you




Running out of Drive Space & Adding a 2nd File


(Not sure if the DB Engine forum is a better place for this q, but thought I'd start here first :)


SQL Server 2008, 64bit. 3 File groups (plus a log), each with one physicial file in the group. Each physcial file is on it's own drive. File group X has a file "X1" and is growing and dangerously close to running out of space on the drive. I added a second file ("X2") to the X filegroup on a different drive with plenty of space as follows:


I was under the impression that the files would grow equally in parallel... the 2nd file is still 100MB, but probably because X1 has not experienced growth yet. My question is... Am I in any danger since the X1 file may run out of space, or will the data automatically redirect over to the X2 file as needed?

How do I get rid of .Net Framework? I went from 25 g free space to 8 g on a 55 g hard drive

Why can't I remove older versions of .NET Framework which is using valueble space on my hard drive. I have an older Dell computer that I purchased from a business which was networked, but I have retired and am having problems getting rid of over 400 mb of drive space which is all verions of .Net Framework

Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

Free Code Snippets - ASP.NET

You Can Find Useful ASP.NET Related Posts on the above link.

Free Code Snippets - C#

Free C# Code Snippets

Free Series of SharePoint Workflow How-to Videos

This is the series of "How to" Document Workflow with SharePoint using Visual Studio 2008 (using the .NET Framework 3.0 for backward compatibility to Visual Studio 2005). I have created video's that show the most common requests that I have seen around MOSS/SharePoint 2007 workflow & document workflow.

DataTable - Load from IDataReader - CreateDataReader - ReadXml WriteXml - Free ADO.NET Tutorials

The DataTable in ADO.NET 2.0 has been seriously beefed up and I absolutely love it. Not everything we consume deals with multiple resultsets and requires the ever popular DataSet. With the cool new features in the ADO.NET 2.0 DataTable, we can get many of the cool features in the DataSet without all the extra baggage and memory footprint particular to multiple resultsets.

Load DataTable from IDataReader

ActiveSync 4.5 (Free Down Load) using in Windows Mobile Pocket Pc

Microsoft ActiveSync 4.5 is the latest sync software release for Windows Mobile-powered devices. ActiveSync provides a great synchronization experience with Windows®-powered PCs and Microsoft Outlook right out of the box.


* Faster file transfer speed and photo sync via Outlook are only available for Windows Mobile 5.0 powered devices.
* Remote PC Sync (via WiFi or LAN) has been removed due to Enterprise customer feedback around security issues.
* Customers using Microsoft Exchange 2003 Service Pack 2 with devices running the Messaging and Security Feature Pack for Windows Mobile 5.0 will benefit from the following feature enhancements included in ActiveSync 4.5: Direct Push Technology, local device wipe, and certificate powered authentication to Microsoft Exchange.
* Microsoft® Outlook® 2000 is not supported by ActiveSync 4.5. It is highly recommended that users upgrade to Microsoft® Outlook® 2003 messaging and collaboration client.
* Conversion of database files for use on a mobile device is not supported by ActiveSync 4.5. On previous versions, this feature was limited to devices running Windows Mobile software for Pocket PC 2003 and earlier.
* Conversion of font files for use on a mobile device is not supported by ActiveSync 4.5. On previous versions, this feature was limited to devices running Windows Mobile software for Pocket P

Free BarCode Software

Bar Code Specifications

There are more than 300 different types of barcodes, all with their own specifications. You will find detailed specifications of many popular bar code symbologies and where you can order the official specifications here at BarCode-1.

Barcode-1 Specification Sources Page list the most popular barcodes. It has links to technical information and is a good place to start.
The UPC/EAN Barcode Page lists the details of UPC barcode, and EAN barcode, the type used in grocery stores.
UCC128, EAN128 and GS1-128 Page lists the details for this important standard for marking shipping cartons.
The Code 39 Barcode Page has the details for Code 39 barcode, the most popular barcode used in industrial application.
The Code 128 Barcode Page has the details for Code 128 barcode, a barcode that can encode the entire ASCII character set.
The Interleaved 2 of 5 (I 2 of 5) Barcode Page has the details of this popular barcode.
The NW-7 Barcode Page has the details about this popular barcode in Japan.
The Plessey Code Barcode Page has the details for the historically important barcode.
The 2D Barcode Page lists the most popular two dimensional barcodes. It has links to technical information and is a good place to start if you a looking for 2D barcode information.
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