New answers tagged


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 ...


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-...


Try to edit the script (/opt/mssql/lib/mssql-conf/ using text editor, It is line 1: #!/usr/bin/python22, which may be wrong. I changed it #!/usr/bin/python2 Plz try this


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 = ...


I found the solution. It is because my account doesn't have sufficient permission.

Top 50 recent answers are included