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.

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

Unable to copy an elastic pool database into an S1/Standard (with S1 allowed maxsizebytes) with createmode="copy" #1303

Open
vinathar opened this issue Apr 11, 2022 · 1 comment

Comments

@vinathar
Copy link

vinathar commented Apr 11, 2022

PREMISE:
Server 1: Has an elastic pool
Server 2: No elastic pool (Do NOT want to have an elastic pool)

Original Database:
-- On server 1
-- database is on elastic pool
-- MaxSizeBytes = 34359738368 (32 GB)

TASK:
Trying to create a copy of original database into Server 2 with following properties:
-- S1/Standard tier
-- MaxSizeBytes = 268435456000 (250 GB)
-- CreateMode = "Copy"
-- SourceDatabaseId = Original Database.Body.Id

Performing this using Azure API "BeginCreateOrUpdateWithHttpMessagesAsync()"

ERROR/ISSUE:
"The tier 'Standard' does not support the database max size '34359738368' (32 GB)". This means that it is not updating the MaxSizeBytes on the copy database to 268435456000.

NOTE 1: I am able to create this copy IF I don't set the CreateMode to "Copy" and don't set the SourceDatabaseId. But not setting these values creates an empty copy (without data) which defeats the whole purpose of a copy.

NOTE 2: I do NOT want to have an elastic pool on Server 2, and do NOT want to convert original database to an S1/Standard either.

What are my options and/or workarounds?

@weidongxu-microsoft
Copy link
Member

The lib is in maintenance. Please plan switch to https://aka.ms/azsdk/dotnet/mgmt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants