Monthly Archives: March 2012

There is not enough space available on the disk(s) to complete this operation

When you want to resize the disk in Windows 7, server 2008 or server 2008 R2, you might get this warning:

Error: there is not enough space available on the disk(s) to complete this operation

This could be fixed by the following guides:

  1. Right click on my computer
  2. Click on Manage
  3. Goto storage
  4. Click on Disk management
  5. Right click on disk management and click on rescan disks
  6. Try to resize the disk again

Change SQL Collation

Steps for chaning Collation:

  1. Take backup of Databases and logins.
  2. Detach all databases execpt system databases. (All users databases)
  3. Find the SQL server installation path (Root of the CD)
  4. Run this command:
    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SAPWD=Qwerty123 /SQLSYSADMINACCOUNTS=”administrator” /SQLCollation=SQL_Scandinavian_Cp850_CS_AS

/QUIET – Run it as a sillent installation

/action – We are running rebuilddatabase to change the server collation

/Instancename – withs instance do you want to change collation on.

/SAPPW -SA password for this instance

/SQLSYSADMINACCOUNTS – An administration account, normally the run you are running this from. The user should be administrator of the SQL Server

/SQLCollation – withs collation should you change to.

 

Problems with GPO and mapped network drive and shortcut

Today i have to create a GPO with a shortcut to an already mapped network drive.

Both the Shortcut and the mapped Network drive is created by GPO.

The mapped network drive mapped fine, but the shortcut wasen’t created at all. The Event viewer toll me that that the shortcut could not be created because the file was not found.

Instead of using File System object, i created a URL Shortcut, still to the exe file. This works, but now the icon was a Internet Explorer Icon.

In GPO you can customize the icon, under icon file path

.