You can't restore a file or filegroup without restoring the PRIMARY filegroup. There are a number of reasons for this given your scenario:
Under SIMPLE mode, a Partial Backup always contains the PRIMARY filegroup and all read/write filegroups. You would need to switch to FULL recovery to utilise file/filegroup only backups that can exclude the PRIMARY.
I tried to work on this question...I hope it helps who is looking for it.The solution script is as follows:
Set-AzContext -SubscriptionId $subscriptionId
Create a new resource group
$resourceGroup = New-AzResourceGroup -Name $resourceGroupName -Location $location
Create a new server with a system wide unique server name
$server = New-...
You can get some info by inspecting a backup file using the RESTORE HEADERONLY command. The linked documentation explains what all of the result set fields are and mean, but the ones you are looking for should be:
8 = SQL Server 2000
9 = SQL Server 2005
10 = SQL Server 2008 or 2008 R2 (see [SoftwareVersionMinor] for distinction)
11 = ...