New answers tagged restore
3
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.
If ...
0
I tried to work on this question...I hope it helps who is looking for it.The solution script is as follows:
Set subscription
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-...
0
Try to edit the script (/opt/mssql/lib/mssql-conf/mssql-conf.py) using text editor, It is line 1: #!/usr/bin/python22, which may be wrong.
I changed it #!/usr/bin/python2
Plz try this
18
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:
[SoftwareVersionMajor]
8 = SQL Server 2000
9 = SQL Server 2005
10 = SQL Server 2008 or 2008 R2 (see [SoftwareVersionMinor] for distinction)
11 = ...
0
I found the solution. It is because my account doesn't have sufficient permission.
Top 50 recent answers are included
