.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

Running out of Drive Space & Adding a 2nd File

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server

(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?

View Complete Post

More Related Resource Links

Error Running SSIS Package as SQL Agent Job loading a file from network drive, works fine in bids an

Having problems reading an excel file from a networked drive while running a package as a SQL Agent job step as a type "SQL Server Integration Services Package". I have agent running as an AD account, and I can use the execute package utility logged in as this account and it works. When I log into the server as this account, I can see the network drive, read/write/create to folders on the drive but when I try to run the agent job it cant find the file. I tried using the unc path in the config file rather than a mapped drive, still no luck. If I use a local drive (c) in the config file, the job works fine so it has to do with the network drive. Running windows server 2003 standard R2, SQL Server 2005 standard sp3. Any ideas out there?

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

Word save file on SharePoint via mapped drive


Hi, I have a Document Library mapped to a drive letter. I am able to browse the drive through Windows Explorer. However when I try to save a document to the drive Word returns, 'Unable to connect to the Web server.' .  I have been unable to find any information regarding this error message. If I try to create a document in the Document Library through Windows Explorer and the mapped drive, I get a different error message: 'Unable to create the file 'New Microsoft Office Word Document.docx' There is no user session key for the specified logon session.' After I click OKand refresh the directory, a 0 KB New Microsoft Word Document.docx file has been created. When that file is opened, it is in Read-Only mode.


Windows Server 2003 R2
Webclient service started
Signed into the Microsoft Online Services Sign in Application
IE configured through the sign in application
site added to the trusted sites in IE

Thank you again for your input.

Why does .NET Framework require 841 MB hard drive space on C:

Just downloaded .NET Framework 4 from Microsoft website. Installation says it requires 841 MB space on my C: drive. Why so much? I am presuming that this is in addition to the space for the other versions of .net installed. This is not going to be installed without a very good reason for this much space required. Can anybody enlighten me on this? Any way to lighten the space requirement load?  

Adding More File Upload Controls ???

Hi.........I have added a file upload control and tried to upload a image with image name...it was succesfull..Now when i click Add More Photos....i want fileupload controls to be added...(without using JavaScript)like it happened HERE Can anyone help me with this...............

Consistently running out of page file memory with full text indexer

Using MS SQL Server 2008 SP1 x64 Standard Edtion on Windows 2008 R2 Enterprise, I'm about to full-text index for the first time 1 table and 2 views. The table contains about 250'000 entries with a data space of 180 MB. As soon as I activate the full text indexing, the fdhost.exe task starts to consume slowly but surely all the available page file space (this can be easily watched using the Resource Monitor and the Commit Charge graph on the memory tab). Once all the virtual memory has been consumed, the server becomes unusable since it can't open any new windows any more, and RDP stops working. The machine specs are as follows: 12 GB of RAM 80 GB free on hard disk out of 136 GB 8 CPUs Custom size paging file with sizes between 24 GB - 60 GB (originally, this was system managed size, but then the server ran out of memory sooner) Max SQL server memory set to 6 GB (first 10 GB, then 8 GB) I've set the max fulltext crawl range to 8. During the indexing, the 8 CPUs are bit busy for a while, but not excessively. What is astonishing is that there is almost no use of physical memory during the indexing (I can see an increase from 2 GB to 3 GB which still leaves plenty of RAM available). Does anybody have an idea how I can convince fdhost.exe to consume physical memory and leave the paging memory alone? Or what else can I try?

Problems running a bat file within a SSIS package

I have a ssis package which has 2 tasks, first it builds an excel sheet with data on the server from where I am running the ssis pkg and the second task (a sql process task), runs a bat. the bat file that basically copies the  excel sheet created from the first step to another server. Problem is that the ssis pkg runs succesful when i run it from BIDS, bust when I run is as ajon, it gets hung. It completes the first step, it is the sescond step that is get hung. I noticed that when i run from BIDs, it does come up with a window open file - security warning and says the publisher could not be verified, are you sure you want to run this software. why does it do that ??? the file I am asking to run is a .bat file. it should automatically use the cmd.exe app to run the bat file. Please help !!!   Thanks in advance.

Scrollbar disappear when adding an attached file in MOSS 2010

Hi, When adding a new element in my SharePoint list, the vertical scrollbar is OK. But when I click on the attached file button to upload a file and back to the list form, the scrollbar disappears !! It's impossible to access the "save" button at the back of the form. Any issue to that problem ? Best Regards, François

Scrollbar disappear when adding an attached file in MOSS 2010

Hi, When adding a new element in my SharePoint list, the vertical scrollbar is OK. But when I click on the attached file button to upload a file and back to the list form, the scrollbar disappears !! It's impossible to access the "save" button at the back of the form. Any issue to that problem ? Best Regards, François

Can not find file when running app (I give up!!!)

Ok, I give Up!!!I created a deployment project in VS 2008.   It packages a Windows forms app.1- My application includes two XML files that that it needs to read from.  Those files were added into the solution.2- After installing the app via my deplyoment project, the app can not find the XML files that it needs,  it tells me that System IO can't find the XML files3- I notice that when the files are read, the app tries to read from the User\myprograms etc area.  Sometimes they are read from windows\system32 4- After I had added the files to my Windows forms app  I never specified a path when retrieving.  I figured the system was going to choose the application folder once deplyed and read from the same.  Maybe this is where the fault exists.  The application runs fine from Visual Studio.Can someone tell me if I have to specify a folder or if I have to use some sort of default syntax to make sure the files are written and read from the application folder.  The XML files have had the write always property set to true.I have tried moving the files around to no avail.  The code that loads one of the files is simply:xelement doc = xelement.load("myxmlFile.xml");??? NR

Adding New Column to XSD File Without Remapping existing Transformations

Hello, I am loading XML file using SQL 2005 SSIS and using XSD file for XML Schema defination. Now I have a requirement where I should add couple of new columns in XSD as the XML (MAY) have extra columns for few of its tables. Is it safe to add new columns to XSD and the Map only new columns in Data Flow and all will work? or after I add new columns I need to redesign all mappings as Column order will change. (I think SSIS refere a numeric value for each column, if Yes how can I add new column with less impact)? Thanks, Prabhat Nath

uploading a file with wcf works fine with local drive, but only 4096 kb uploaded when I use unc stor

Hello I'm writing a wcf service for uploading files to a server. It works fine when I try to upload the file to the servers local c:/ drive, but if I use a UNC path only 4096 kb is stored. It actually looks like part of the file is lost while storing it with writeStream.Write(buffer, 0, bytesRead);, because I wrote the bytesread to an sql table and the number of elements are always the same no matter how many times I upload the file, but the stored file is always different sizes, ranging from 1996 kb to 4092 kb.   I'm using IIS 7.5 on a windows 7 enterprise machine. My IIS is using a administrator account for the application pool, so it should not be a problem with permissions.   My wcf method uses Stream to upload the file in chunks    public void UploadFile(RemoteFileInfo request)         { //some methods to set the filepath                                   int chunkSize = 4096;                                 byte[] buffer = new byte[chunkSize];                                 Stream writeStream = new FileStream(filePath, FileMode.CreateNew, FileAccess.Write);  &

File Rename Problem(Space Problem)

i create a web site for file file uploading and download      My File name is            Hello File1      But we download the file the name is changed in      Hello        

hard drive space


Does anyone know the minimum space required on the install partition so that the analyzer does not throw any warnings? 
We are strapped for space and the recommended 80 GBs is not a option for us.

Thanks in advance.

Need help running sql as batch file that creates a list of borrowers


Our application database was recently upgraded from mssql server 2000 to 2008.  I am unable to get a batch file that creates a list of updated
borrowers to run.  It was running fine on Windows server 2000 (even after the upgrade to mssql 2008), but I
recently wiped that old server and installed windows server 2003.  The
drive that the file lives on changed, so I changed the name in the
file, but it will not run.  When I try to run it from a command prompt
I get the error:

'melcat_daily_borr_export.bat' is not recognized as an internal or
external command, operable program or batch file.

The text of the file is :
isql -S192.168.36.2 -Pmypassword -Umyusername
-iD:\Horizon\melcat\melcat_daily_borr_export.txt -b -h-1 -n -w800 -O

I have tried running the command with the name in quotes, I have
changed the file to a .cmd rather than a .bat, all to no avail.  The
sql that the file calls will run and return results.  Yes I am using
my proper user name and password.

The text of the sql called is this:

use horizon

set nocount on



Move folder from file share to local C:/ drive on same box



I need to copy a folder from a file share to my local C: drive. Is there an easy way to do this in SSIS, or do I have to write a DOS batch file and execute it from SSIS.

Any help would be appreciated


Dave SQL Developer

Adding a server control on aspx page does not add events in aspx.designer.vb file



I work in VS 2008. Whenver I add a server control(Label) and set it properties in aspx.vb and build the solution, I get the error "Label1 not declared". While analyzing this issue I noticed that the event handler statements for the Label1 where not added in the designer.asp.vb file. These statement would actually be added automatically when I drag and drop a control to my webpage.

I would also like to inform the scenario after which this problem came to me. I was working in VS 2008 , VS 2005 and VS 2003 in the same machine.Could this have caused the issue ? Please advise.

Now each and everytime when I add a control, I am adding the "With Events" code in the designer page to make my build succesfull which makes me to spend more efforts.

Please advise if any settings have to be changed.



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