.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

Installation filling up System Drive

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server
I have a question regarding Installation of SQL.

Whenever I have my installation files located on D:\(for example), and I instruct SQL during installation to install everything to D:\, there are still a ton of files that get copied to the C:\ partition (%SYSTEMDRIVE%). This is a big problem for me, as most of the customers site I install and configure SQL on, has a very limited amount of space on there System Drive.

Is there a way to make SQL dump these file (Im guessing setup support files and such) to another drive during installation, so the System Drive is not impacted whatsoever?

Also, when ever I install the Service Pack for SQL, even though SQL is installed on D:\, my System Drive (C:\) shrinks dramatically. As with the above question, is there a way to prevent this from happening?

Thanks in advance for any help.

View Complete Post

More Related Resource Links

SQl server 2008 installation is a different drive


1. Can I isntall sql server 2008 is different drive other than C. What is the best practice.

2. Due to a corrupted DB my SQl server generated huge log files and dump files that my C drive ran out of space. So is there an option in the maintenance plan to clean up SQL error log file which is located in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log .




SQL Server 2008 Installation on SBS 2003 - Rule "Operating system supported for edition" failed


I'm trying to install SQL Server 2008 for Small Business, on a Windows Server 2003 SBS, which is a Domain Controller on a less than 50 users ' domain. I'm logged in with the Administrator account, wich belongs to the 'Doman admins' group also. Setup failed with this error:

2010-09-25 11:55:34 Slp: EditionRequirementCheck Rule Check : The edition is not allowed on this OS.
2010-09-25 11:55:34 Slp: Evaluating rule        : EditionRequirementCheck
2010-09-25 11:55:34 Slp: Rule running on machine: DELL1
2010-09-25 11:55:34 Slp: Rule evaluation done   : Failed
2010-09-25 11:55:34 Slp: Rule evaluation message: This SQL Server edition is not supported on this operating system. See SQL Server Books Online for information about supported operating systems for SQL Small Business Server edition.

According to this link, this version is supported on Windows Server 2003 SBS: http://msdn.microsoft.com/en-us/library/ms143506%28SQL.100%29.aspx#SE32

I've tried to diagnose the error, after reading this link: http://blogs.technet.com/b/sbs/archive/2010/07/21/how-to-diagnose-quot-operating-system-supported-for-edition-quot-pre-requisite-errors-while-installing-sql-2008-standard-edition-for-small-business.aspx

After a new

SSMS - Database is filling up (Disk Drive)


Good day, i need help please.

Yesterday I shrunk the Transaction Log file which freed up a lot of space, but now i shrink the log again i only have 5GB space available on Drive.

The SSIS task i run is hectic & is filling up the space on Disk Drive

Please i'm no DBA, but can i shrink the database (database - tasks - shrink - database)

Please help

Installation issue - E drive is being referred to, when it should be referring to my C: drive.

I am having a problem after installing this software.

Event viewer is showing that the server service is trying to open database files on my E drive.

FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 3(failed to retrieve text for this error. Reason: 1815).

I did not install the software from the E drive as it was installed using the WEB PLATFORM INSTALLER.
I did not install it on the E drive (as this is assigned to my DVD drive.  I have no idea why it is configured to read the database files in this drive and this path.

In addition to the model database, I am receiving errors in my event viewer related to the following files:-


Both of these reside in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

If the master database and other databases such as the model database can not be found, I am not surprised that the server is failing to start.

Hopefully someone from Microsoft can help sort out this issue and provide us with a solution soon.

System Development Life Cycle

The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology

The Agile System Development Life Cycle (SDLC)

The goal of this article is to describe the agile system development life cycle (SDLC), putting it in context from what you may have heard about within the agile community and more importantly within the context of your overall IT efforts.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ

Problem upgrading to MVC3 - System.Web.Routing



I'm trying to upgrade to .NET 4 and MVC 3.

When trying to compile my project, I get the error:

Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside!  The System.Web.Routing namespace is not in there - the entire thing is empty!  Could it that the dll is corrupted?  I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

The dll is coming from here:

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll

and the runti

System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm


Good Day all,

Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. 

What do you think my approach should be. 

I already have read rights to IIS user to my BIN folder. 

Thanks for the help. 

Installation problem with VWD 2010 on XP sp3.



I have installed Xp sp3 in my system.When ever i install VWD 2010. I will get auto shutdown of System. But it support vs 2005, VWD 2008 Sp1 with sql 2005 very well without any problem. Again whenever i try to Sql server 2008 express. I will get auto shutdown problem.

But i have read on Microsoft site, VWD 2010 and sql 2008 support XP sp3.  My system does not support good graphic and sound in Window 7 OS. I have MSI mother board and AMD dual core processor with 2 GB Ram.

what is the problem ? is there problem with hardware ?

System.IO.Packaging is not visible


I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).

For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?

Thanks in advance.

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must



This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'.


On web.config I already have this:
<add assembly="System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?


System.Xml.Linq.XElement and XPathDocument


I have an XPathDocument that I want to save to a table using LINQ, but I get this error

cannot implicitly convert type 'System.Xml.XPath.XPathDocument' to 'System.Xml.Linq.XElement'

I create the XPathDocument from some (valid) xml contained in a resource file

XPathDocument xDoc = new XPathDocument(new StringReader(Resource1.TestXML));

when I try to assign it with LINQ, it flags up an error

NewDataItem.XML = xDoc  ----  error here

NewDataitem is a LINQ to SQL object created from the underlying table, 'NewDataItem.XML' is a column type of 'XML'

how do i (easily) convert xDoc so I can pass it into the LINQ object ?

I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary


I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary to store Fees information ...


System.DirectoryServices NOT available


I have simply copied a page from a VS2005 project to a VS2010 project, and it will not work.

NO code-behind, just a simple Page_Load function in the .aspx page.

and okay, since this editor complete f's up a cut and paste from VS, I will type it all out....wonderful!


<script runat="server">

protected void Page_Load(object sender, EvnetArgs e)


   System.DirectoryServices.DirectoryEntry ...



This is really all you need to see.

The System.DirectoryServices is not available in intellisense and gives an error if I try to run this.

I have added the reference to my VS project - no go.

I have added a reference as an @Import at the top of the page - no go.

All other System classes appear to be available, but not DirectoryServices, so anyone know the secret handshake to get this to work in VS 2010?

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