.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server Specs of Hard Drive

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Hi, Is there a SQL Server script that gives information about a hard drive, like the size of the Hard Drive, Free space and how much of the hard drive is used?

View Complete Post

More Related Resource Links

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?  

Sql server Report services integration with moss 2007 giving hard time.

Hey guys, I have 2 servers  in seperate domain one for database and other for moss 2007. SERVER 1 :     AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2:    MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <passw

know the hard disk's SQL Server space available from SQL Query



I would be able to determine how much hard disk space is available on the Server with a SQL Query, and from an other computer on the LAN.


How can I do something?


Thanks for your help.

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 .




Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

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.

SQL Server does not detect new clustered SAN Drive


I just joined this organization as a SQL Developer/DBA and manage some of the servers there. One of the applications has a dedicated Win 2003 server for Production running SQL Server 2005 on an Active/Passive Cluster. We requested the storage team for a new SAN Drive be included to the existing cluster so that the daily backups be routed to that Drive (G:) allowing the application enough space on the Data Drive (E:).

The storage team successfully assigned the new SAN Drive to both the clusters after a re-scan. The new drive was available to the OS either to the Active Node (Node 1) or to the Passive Node (Node 2) after failover. But somehow, SQL Server does not recognize this drive as part of its resources and so I am not able to route my backups to the new drive (G :).

Below are the configurations of the cluster.

The server has three Groups in Cluster Administrator as Cluster Group. Group 0 and Group 1.

Specs for a small Sharepoint 2010 farm on a Hyper V virtual server


I want to build a small Sharepoint Farm on a hyper v Windows Server 2008 R2 OS.

I want to have the following instances. An App server (with indexing and query) and an SQL server.

I need to scope out a server which will accommodate this development environment and ultimately scale out to include additional virtual instances.

What would the minimum memory and CPU requirements be?


Bazin Makonnen

How to access Client hard drive?


I am working on a web application where I want to keep all the user specific data at client side.

My user will select a location at client side through settings page where he/she wants to save the data.

Is there a way I can do this?

Adding Instance(SQL Server 2008 R2) and Moving Quorum Drive


Hi all,

I am Planning to Add new SQl Server 2008R2 Instance to SQL Server 2000 SP4 in Windows 2003 SP2 OS and As of now all the storage in SAN drive

Here problem is my company is going to move SAN drive to iSCSI and they given me iSCSI drives to Install SQL Server 2008R2 and they ask me Create Quorum drive on iSCSI.

1. Is it possible to create one more  Quorum  Drive or I need to move excisting Quorum to new Drive

I have below Groups in SAN Drive and I want Move those groups to iSCSI Drives what is best way ..to do this  with minimum Down time.

Cluster Group
Cluster Ip Adress
Cluster Name
MSDTC NetworkName

Disk G:
Disk L
SQL Server Name
SQL Server Agent
SQL Server Fulltext



Thanks in Advance



Hard drive crashed - no backup - Files saved, cannot attach sql db



the people called me in their firm because server Won't boot-up (SQL 2000).

I checked it and it was hard drive failure. Manage to get DB data from HD, i wanted to put it on SQL 2005 on new machine.

I successfully attached 5 databases, they are working now, but have problem with 6th. When i trying to attach it get the error;

Server Name: PROMET
Error Number: 9004
Severity: 21
State: 1
Line Number: 1

.mdf file has 1.3 gigs and .ldf 6.1 gig

I searching trough the forums all day, and i cannot find working answer...

Please help me, i can provide additional information if 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

Moving the Quorum drive to new SAN (SQL Server 2005)



  I have an active/passive cluster installed on Windows 2003 Ent ed with SQL Server 2005 installed. Currently we are planning to move to the new SAN. Can you give me detailed steps (with screenshots if possible) or links on how to move quorum and msdtc resources to the new SAN.




Using Microsoft.SqlServer.Management.Smo to backup from remote SQL Server to local drive.


I'm trying to use the Microsoft.SqlServer.Management.Smo class to connect to a remote SQL Server, perform a backup and save it to my local drive.

I currently can only connect to a remote SQL Server and backup and save the backup file to the remote SQL Server drives. The same happens when I connect to a local instance of SQL Server and backup a file, I can only save it to my local drive.

Is there a way to specify to the Microsoft.SqlServer.Management.Smo to save to the [local] or [remote] machines?

Patrick Miron

For more about Microsoft.SqlServer.Management.Smo, check out my other thread at http://social.msdn.microsoft.com/Forums/en-CA/sqlgetstarted/thread/656d522a-06a6-4475-8070-93df75ef83a5

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.
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