Windows C Drive space constraint solution

-
Hi Guys, I was facing a lot of issues with c drive space constraints. First i had my c Drive with 60 GB Space. But as i am a developer. installing software itsef consumed 50 GB of that. and only 10 GB left.  Somehow I managed to handle this space constraint for sometime. and then got my hard disk formatted and repartitioned for 110 GB. So, Now my c Drive is 110 GB.

After sometime i saw that whole of c drive is now used with only 300 MB left.  When i analysed bit further the Sql server database itself was over 60 GB with only data files over 51GB.

I used software named Symmover to move the data files to D Drive which had enough space. Symmover provide very nice GUI  to do this task. and incase you wants to revert back sometime later you can just do it again.

only thing you have to take care when using this software is you have to stop the services related to the software you are moving. In my case i went to local services and stopped all the sql server services. and once the data files moved to d drive i again started the sql server services mannually and oh my . now i have 52 GB empty in my c drive. below is the link to this great software http://mobasoftware.com/symmover.php

Comments

Post a Comment

Popular posts from this blog

Authorize.net Integration eCommerce Payment Gateway ( Direct Post Method New! )

-
https://developer.authorize.net/integration/fifteenminutes/csharp These steps assume that your web server is on the public internet and can be accessed via a domain name or IP address. Step 1:Sign up for a Test Account. Sign up for a test account to obtain an API Login ID and Transaction Key. These keys will authenticate requests to the payment gateway. Step 2: Download the Authorize.Net C# SDK and include it in your project Download the SDK Create a new ASP.NET MVC application and add a reference to the AuthorizeNET.dll from the SDK Step 3: Modify web.config. Add the AuthorizeNET.Helpers namespace to the web.config, under system.web/pages: ... Step 4: Create a checkout form that posts directly to Authorize.Net Add the following code to the Home/Index View - this will create a form which will submit a test transaction to Authorize.Net (with hardcoded values). This code uses the SDKs CheckoutFormBuilder to create the form for you - just include your API login and Transa
Read more

Get Organised with OneNote

-
One note is greate tool to get organised and in todays world of information explosion. you may need any set of information weather financial, personal, or expenses or your assets your insurence etc. onenote is the best way and easiest way to manage this info. only thing to do is create templates for eash of these stuffs and you can add info as and when required. you can also, attach the scanned documents with the records in onenotes. For example, monthly phone bill. Below is good link which explains how to utilise onenote and how to find better templates for your use. Click Here
Read more

Test your Sql Query Online

-
Hi Guys i found a good tool to test simple Sql query online the link is as below. This time i used this to test the pivot functionality. The Pivot Sql Function converts the row wise category data into column wise metrix/pivot kind of data. http://www.sqlfiddle.com/#!3/b228e/3 another good example is below http://sqlfiddle.com/#!6/2ba07/131
Read more