View Complete Post
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?
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?
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
(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:
ALTER DATABASE MyDB ADD FILE (NAME = X2, FILENAME = 'V:\X2.ndf', SIZE=100MB, FILEGROWTH=1000MB) TO FILEGROUP X
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?
in my MVC 2 application, and in the shared Master Page I wrote this little script for menu handling :
The script, that shows menu items when the
Seems like a stupid question, but I will go to Build > Build Solution many many times and the build will succeed many many times, then I will put in a minor syntax error and the build will fail, BUT the build will not fail because of the minor syntax error; it will fail because of an unresolved type that I put in about twenty compiles ago. And then I will fix the minor syntax eror, and the compiler will still complain about the unresolved type. Here is my code:
<%@ Register TagPrefix="FTB" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %><html><body> <form runat="server"> Hello World!! </form></body></html>
Pretty simple, really. I go to Buld > Build WebApplication1 and it runs OK. Now, if I put in a minor syntax error, such as substitute "forrrrrrrm" for "form" and then try to Build Solution, it complains not about the misspelled word, but about the FreeTextBox. And then if I correct the misspelled wird, it still complains about the FreeTextBox. Which leads me to believe that Building the Solution does not check absolutely 100% everything that needs to be checked. Is there a more thorough way of compiling a program that I need to use?