Creating additional disk partition on windows server 2012 R2

Paul Lemon
Paul Lemon used Ask the Experts™
on
Hi, I am trying to create an additional drive partition in Windows server 2012 R2 but keep receiving the error 'you cannot create a new volume in this unallocated space because the disk already contains the max number of partitions'

We currently have 3 partitions setup and i want to create a fourth.

Is there a way around this?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
This is a MBR partitioned disk. For MBR partitioned disks is no way around this. It can't hold more than 4 primary partitions or 3 primary partitions and 1 extended partition.

You could convert it to GPT but Windows Server 2012 R2 can do this only for empty disks.
There are only 3rd party tools to do it on dsiks holding data, i.e. https://www.disk-partition.com/server-2012/convert-mbr-to-gpt-server-2012-3889.html
AlexSenior Infrastructure Analyst

Commented:
The above is bang on, you already have the limit of partitions, what you can however do is create a new volume, then throw in a mount point into a suitable location. What sort of server is it, exchange, SQL etc? Is it physical or virtual?

Thanks
Alex
Paul LemonI.T. Manager

Author

Commented:
Hi, thanks for your replies. Its a SQL physical server.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Paul LemonI.T. Manager

Author

Commented:
Also just found that Computer Management console is not showing Local Users and Groups?? I have inherited this server and finding my way around.
AlexSenior Infrastructure Analyst

Commented:
Right,

I mean what you could do is this, if you really really wanted to, connect up an additional array, backup the data, convert it to GPT and then hope it doesn't mess up your database.

Alternatively, any change of throwing it on VMware or something?

Thanks
Alex
>>  Computer Management console is not showing Local Users and Groups??

Its a domain controller?
Paul LemonI.T. Manager

Author

Commented:
I think messing up this database is a career ender!

Not familiar with VMware. Is there any info as the number of servers are growing at an alarming rate?
Paul LemonI.T. Manager

Author

Commented:
Computer Management console is not showing Local Users and Groups?? We don't currently have a domain controller (my net job) its just a server with Windows server 2012 R2 runnig SQL server. I just want to add another account login to restrict access to a particular folder if i cant add another disk partition.
What happens if you start the console for local users? its just blank?
or open an elevated command prompt and run
lusrmgr.msc

Open in new window

noxchoIT Product Manager
Top Expert 2009

Commented:
Can you show us a screenshot of your Windows Disk Management?
>>Not familiar with VMware. Is there any info as the number of servers are growing at an alarming rate?

I'd get a supplier that creates a decent VMware (or other hypervisor) infrastructure for you.
Your requirements (or your user's requirements) are needed to decide about how complex it will be.
I.e. if  high availability is required, distributed on different locations and so on...

In addtion you can migrate your physical servers to your virtualization.
AlexSenior Infrastructure Analyst

Commented:
Don't bother with a supplier, realistically it's so simple.

Get 2 or more servers, that's a minimum, I'd personally go with 4 and then have excellent redundancy.

take those 4 boxes, install ESXi 6.7 on there.

deploy your 6.7 VCSA

Preferably get some sort of shared storage, if you have a SAN perfect, if not, get some MSA's or use the internal disks, I'd probably RAID6 them.

Get HBA's to connect between the hosts, you'll also need a fibre switch, this is for your V-Motion network etc. You could stick it with some 1GB network cards, team them up for 2Gb.

Use VMware converter, convert the physical host over to your new cluster.

Take all your other servers, virtualise those off.

Get some Nice HP DL360 Gen10's

You could get the hardware for as little as £15k easily. Maybe even less.
Paul LemonI.T. Manager

Author

Commented:
Can you show us a screenshot of your Windows Disk Management? Here is a screen shot of the computer management console showing no option for Local Users and Groups  Capture.PNG
AlexSenior Infrastructure Analyst

Commented:
go to

Control Panel\All Control Panel Items

then user accounts, you should see it in there. Yes, you can copy and paste that into your explorer window

regards

Alex
What happens if you start, i.e. from prompt or via Run...

lusrmgr.msc

Open in new window

Paul LemonI.T. Manager

Author

Commented:
Hi get the message 'The Computer is a domain controller' which is a revelation. I inherited this server and thought it had just been setup to run our SQL database!  I am in the process of adding a dedicated domain server which i assume will cause problems if i connect it to the older server with oour SQL database on it?
Top Expert 2016
Commented:
you can only have 3 primary partitions
if you copy off one of them (the rightmost one) and delete the partition then create an extended partition and you can create as many logical drives as you want within this partition
https://www.partitionwizard.com/partitionmanager/primary-partition-vs-logical-drive.html
Paul LemonI.T. Manager

Author

Commented:
That's great. Solves my partition problem. Not sure what to do about the SQL server being a domain server? Is it a full rebuild to swap its setup/role or can i still connect my dedicated domain server and maybe swap the SQL server out later if you see what i mean?
Verify how many domain controllers you have.
You should have at least 2 additional domain controllers. When done demote the SQL server.
Its not recommended to run add'l software on a domain controller except in very small setups
Paul LemonI.T. Manager

Author

Commented:
How do you go about demoting the SQL server? Is it a reinstall/rebuild?
Never had to demote a DC with a live SQL on it ...

You can demote it via the GUI.
But: I'd have a look at service accounts used for the SQL services. And have a good idea how to recover in case its going really wrong.

Or you build a new SQL in parallel and migrate the SQL databases... this is much safer because you switch to the new server after its running fine.
Paul LemonI.T. Manager

Author

Commented:
The New SQL server sounds like the safer option.

Many Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial