Change Interwoven Docstore and Index locations in SQL

First to check the location of the docstore and index type the following in SQL

select * from HK.mhgroup.docservers

To update the two items type the following:

update DATABASENAME.mhgroup.docservers set location = ‘\NEWSERVERNAMEwsdocs$’ where docserver = ‘defserver’
update DATABASENAME.mhgroup.docservers set location = ‘\NEWSERVERNAMEwsidx$’ where docserver = ‘idxserver’

Re-size Virtual Machine

First use VMKFSTOOLS to expand the VMDK file.  Putty onto the ESX box and type

1. vmkfstool – X  10g servername.vmdk

This will expand the file to 10gig.  note. the X has to be uppercase and the vmdk should not be the one that ends with  ‘-flat’.

Mount something like BartPE to the virtual machine and boot from it.  Once loaded open and command prompt and type the following:

2. diskpart

3. list volume (note the number of the volume you want to expand)

4. select volume x (x = the volume number)

5. extend

6. exit

All done!