New answers tagged

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