Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

RestoreSqlDatabaseToSqlDatabase fails when source database is in an Elastic Pool #15

Closed
asiffermann opened this issue Jun 13, 2017 · 1 comment
Closed

RestoreSqlDatabaseToSqlDatabase fails when source database is in an Elastic Pool #15

asiffermann opened this issue Jun 13, 2017 · 1 comment
Assignees
@asiffermann
Labels
bug

Comments

@asiffermann
Copy link
Member

asiffermann commented Jun 13, 2017 •
edited
Loading

We are missing some parameters to successfully restore a database from an Elastic Pool:

2017-06-12T16:32:06.3531971Z ##[debug]Env:PSModulePath: 'C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files\WindowsPowerShell\Modules\;C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\ResourceManager\AzureResourceManager\;C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\ServiceManagement\;C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\Storage\;C:\Program Files\Microsoft SQL Server\130\Tools\PowerShell\Modules\'
2017-06-12T16:32:06.3688228Z ##[debug]Attempting to find the module 'AzureRM' from the module path.
2017-06-12T16:32:06.4625698Z ##[debug]Checking if path exists: C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\ResourceManager\AzureResourceManager\AzureRM.Profile\AzureRM.Profile.psd1
2017-06-12T16:32:06.4625698Z ##[command]Import-Module -Name C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\ResourceManager\AzureResourceManager\AzureRM.Profile\AzureRM.Profile.psd1 -Global
2017-06-12T16:32:10.8065217Z ##[debug]Imported module version: 0.0 1.0.7
2017-06-12T16:32:10.8377730Z ##[debug]Set-UserAgent failed with exception message: Unable to find type [Microsoft.Azure.Common.Authentication.AzureSession]. Make sure that the assembly that contains this type is loaded..Exception.Message
2017-06-12T16:32:10.9784004Z ##[command]Add-AzureRMAccount -ServicePrincipal -Tenant df281155-aeec-4a7d-98eb-05b35c26cb32 -Credential System.Management.Automation.PSCredential
2017-06-12T16:32:12.0342814Z ##[command]Select-AzureRMSubscription -SubscriptionId 6b983d64-a48b-4370-9772-dedc91b16222 -TenantId df281155-aeec-4a7d-98eb-05b35c26cb32
2017-06-12T16:32:12.1436599Z ##[debug]Installed Azure PowerShell version: 1.0.7
2017-06-12T16:32:12.3780420Z ##[debug]Server friendly name is ServerName
2017-06-12T16:32:12.3780420Z ##[debug][Azure Call] Getting resource details for resource: ServerName with resource type: Microsoft.Sql/servers
2017-06-12T16:32:14.2531314Z ##[debug][Azure Call] Retrieved resource details successfully for resource: ServerName with resource type: Microsoft.Sql/servers
2017-06-12T16:32:14.2687527Z ##[debug]Resource Group Name for 'ServerName' of type 'Microsoft.Sql/servers': 'ResourceGroupName'.
2017-06-12T16:32:14.2687527Z ##[debug][Azure Call] Getting Azure SQL Database details for target TargetDatabase
2017-06-12T16:32:14.7304684Z ##[debug][Azure Call] Azure SQL Database details got for target TargetDatabase :
2017-06-12T16:32:14.7461217Z ##[debug]
2017-06-12T16:32:14.7617169Z ResourceGroupName             : ResourceGroupName
2017-06-12T16:32:14.7617169Z ServerName                    : ServerName
2017-06-12T16:32:14.7617169Z DatabaseName                  : TargetDatabase
2017-06-12T16:32:14.7617169Z Location                      : West Europe
2017-06-12T16:32:14.7617169Z DatabaseId                    : 84795933-891c-4b99-864a-0aa3e9ebfb4b
2017-06-12T16:32:14.7617169Z Edition                       : Standard
2017-06-12T16:32:14.7617169Z CollationName                 : French_CI_AS
2017-06-12T16:32:14.7617169Z CatalogCollation              : 
2017-06-12T16:32:14.7617169Z MaxSizeBytes                  : 268435456000
2017-06-12T16:32:14.7617169Z Status                        : Online
2017-06-12T16:32:14.7617169Z CreationDate                  : 12/22/2016 4:44:34 PM
2017-06-12T16:32:14.7617169Z CurrentServiceObjectiveId     : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:14.7617169Z CurrentServiceObjectiveName   : ElasticPool
2017-06-12T16:32:14.7617169Z RequestedServiceObjectiveId   : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:14.7617169Z RequestedServiceObjectiveName : 
2017-06-12T16:32:14.7617169Z ElasticPoolName               : StandardPool
2017-06-12T16:32:14.7617169Z EarliestRestoreDate           : 5/8/2017 12:00:00 AM
2017-06-12T16:32:14.7617169Z Tags                          : 
2017-06-12T16:32:14.7617169Z ResourceId                    : /subscriptions/6b983d64-a48b-4370-9772-dedc91b16222/resourceGroups/ResourceGroupName/prov
2017-06-12T16:32:14.7617169Z                                 iders/Microsoft.Sql/servers/ServerName/databases/TargetDatabase
2017-06-12T16:32:14.7617169Z CreateMode                    : 
2017-06-12T16:32:14.7617169Z ##[debug][Azure Call] Azure SQL Database TargetDatabase exists: removing it!
2017-06-12T16:32:18.0296478Z ResourceGroupName             : ResourceGroupName
2017-06-12T16:32:18.0296478Z ServerName                    : ServerName
2017-06-12T16:32:18.0296478Z DatabaseName                  : TargetDatabase
2017-06-12T16:32:18.0296478Z Location                      : West Europe
2017-06-12T16:32:18.0296478Z DatabaseId                    : 84795933-891c-4b99-864a-0aa3e9ebfb4b
2017-06-12T16:32:18.0296478Z Edition                       : Standard
2017-06-12T16:32:18.0296478Z CollationName                 : French_CI_AS
2017-06-12T16:32:18.0296478Z CatalogCollation              : 
2017-06-12T16:32:18.0296478Z MaxSizeBytes                  : 268435456000
2017-06-12T16:32:18.0452633Z Status                        : Online
2017-06-12T16:32:18.0452633Z CreationDate                  : 12/22/2016 4:44:34 PM
2017-06-12T16:32:18.0452633Z CurrentServiceObjectiveId     : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:18.0452633Z CurrentServiceObjectiveName   : ElasticPool
2017-06-12T16:32:18.0452633Z RequestedServiceObjectiveId   : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:18.0452633Z RequestedServiceObjectiveName : 
2017-06-12T16:32:18.0452633Z ElasticPoolName               : StandardPool
2017-06-12T16:32:18.0452633Z EarliestRestoreDate           : 5/8/2017 12:00:00 AM
2017-06-12T16:32:18.0452633Z Tags                          : 
2017-06-12T16:32:18.0452633Z ResourceId                    : /subscriptions/6b983d64-a48b-4370-9772-dedc91b16222/resourceGroups/ResourceGroupName/prov
2017-06-12T16:32:18.0452633Z                                 iders/Microsoft.Sql/servers/ServerName/databases/TargetDatabase
2017-06-12T16:32:18.0452633Z CreateMode                    : 
2017-06-12T16:32:18.0452633Z ##[debug][Azure Call] Azure SQL Database TargetDatabase removed
2017-06-12T16:32:18.0452633Z ##[debug][Azure Call] Getting Azure SQL Database details for source SourceDatabase
2017-06-12T16:32:18.1546246Z ##[debug][Azure Call] Azure SQL Database details got for source SourceDatabase :
2017-06-12T16:32:18.1546246Z ##[debug]
2017-06-12T16:32:18.1546246Z ResourceGroupName             : ResourceGroupName
2017-06-12T16:32:18.1546246Z ServerName                    : ServerName
2017-06-12T16:32:18.1546246Z DatabaseName                  : SourceDatabase
2017-06-12T16:32:18.1546246Z Location                      : West Europe
2017-06-12T16:32:18.1546246Z DatabaseId                    : ca36935c-46d3-4b98-ad3f-33845d21ade0
2017-06-12T16:32:18.1546246Z Edition                       : Standard
2017-06-12T16:32:18.1546246Z CollationName                 : French_CI_AS
2017-06-12T16:32:18.1546246Z CatalogCollation              : 
2017-06-12T16:32:18.1546246Z MaxSizeBytes                  : 268435456000
2017-06-12T16:32:18.1546246Z Status                        : Online
2017-06-12T16:32:18.1546246Z CreationDate                  : 6/17/2016 12:38:40 PM
2017-06-12T16:32:18.1546246Z CurrentServiceObjectiveId     : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:18.1546246Z CurrentServiceObjectiveName   : ElasticPool
2017-06-12T16:32:18.1546246Z RequestedServiceObjectiveId   : d1727d22-a8ea-4de7-9bd0-33395d2a7419
2017-06-12T16:32:18.1546246Z RequestedServiceObjectiveName : 
2017-06-12T16:32:18.1702479Z ElasticPoolName               : StandardPool
2017-06-12T16:32:18.1702479Z EarliestRestoreDate           : 5/8/2017 12:00:00 AM
2017-06-12T16:32:18.1702479Z Tags                          : 
2017-06-12T16:32:18.1702479Z ResourceId                    : /subscriptions/6b983d64-a48b-4370-9772-dedc91b16222/resourceGroups/ResourceGroupName/prov
2017-06-12T16:32:18.1702479Z                                 iders/Microsoft.Sql/servers/ServerName/databases/SourceDatabase
2017-06-12T16:32:18.1702479Z CreateMode                    : 
2017-06-12T16:32:18.1702479Z ##[debug][Azure Call] Restoring Azure SQL Database SourceDatabase to TargetDatabase
2017-06-12T16:32:21.3055253Z ##[error]40808: The edition 'Standard' does not support the service objective 'ElasticPool'.
@asiffermann asiffermann self-assigned this Jun 13, 2017
@asiffermann
Copy link
Member Author

asiffermann commented Jun 13, 2017 •
edited
Loading

Fixed in 1.3.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@asiffermann asiffermann

Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@asiffermann