Days ago i tried to update my VCenter (virtual) and UpdateManager on the same guest (i know it’s bad),using vsphere u2 iso.
I came across a little problem: “c:\ not enough free space”.
Another bad thing i’ve made is my SQLServer DB shares the same partition with my XP System,Vcenter Server …..
That’s when i found a useful tool: Microsoft SQL Server Management Studio Express.
My problem is solved, the only thing i need to do is migrate my DB to another partition, here is how to do this:
right after a successful installation, launch the SQL Server Management Studio Express.
As you can see, i have both SQL DB in the same instance: SQLEXP_VIM
Now i want to move the 2 of them in another local partition, wich is in my case E:\
First:
I had to stop all running vmware services:
Second:
right click on VIM_UMDB and choose “Task” and then “detach” (read detacher in french )
Third:
Check if in the message box there is no other connexion to the DB, if not then click “OK” at the bottom left and the screen:
Do exactly the same with VIM_VCDB
Once all DB are detached, move them to another partition.
In my case E:\, i’ve created mssql-vmware-DB folder and put both of them there.
To reattach your DB, it’s easy!
Fifth:
Right click on Database and choose “attach” (read joindre in french)
You’ll have a screen like this one:
Click on the “Add” button, and browse to the folder you’ve moved your mdf files to, choose one of them and click “OK”
Do the same with the other mdf file, restart all vmware services you’ve stopped before, and it’s done !
