I've ended up installing the Ubuntu server version on my server and also create a / partition and a /home parition, as well as a 'swap' partition. Once installed, the command line threw me coz I had no idea what to do from there. I then installed the GUI and have had a look through there. It's strange because I would have thought that I would see the partitions as separate drives but I just see 'Filesystem', CD-ROM, Floppy and after clicking all over the place I have 'print$ on server' (no idea what that is).
Yeah, the Linux way of looking at disks (and other devices) is different from Windows. There are no drive letters; everything is part of one big tree that is linked to your root filesystem. Additional drives are mounted onto directories in the main filesystem... e.g. on my Linux server, the second hard drive is accessed as /data2, the third as /data3, etc. Even low-level data and interfaces are often exposed as part of the filesystem... e.g., try typing the command "cat /proc/cpuinfo" in a command shell (/proc/cpuinfo is a pseudo-file that contains detailed information about the CPU the system is running on).
I think I might revert uninstall, format, reinstall the server version and then try just from the command line or using SSH from my main PC (no idea how to do that but there has to be a way, right?)
Yes, Linux can be managed via command line interface, locally or remotely. But unless you want to go "cold turkey", it is not necessarily the best way to go. FWIW even though I have been an off-and-on UNIX user going back over 20 years, I prefer to install my Linux systems with a GUI, and open terminal windows within the GUI for tasks which require command line access.
If the world isn't making sense to you, you're either drinking too much or not drinking enough.