Brad

My feedback

  1. 37 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Brad supported this idea  · 
  2. 62 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    This is a difficult one to handle technically. However the main theme is cost savings. Are there other cost-saving options (other than pausing) that could address this concern? For example, smaller vCore Managed Instances etc.? On the other hand, implementing pausable Managed Instance can also mean that resuming them will take several hours each time. Is this a concern? Thank you.

    An error occurred while saving the comment
    Brad commented  · 

    Also providing feedback...

    Our use case is for dev/qa environments where we do not need them powered on when our dev team is not working. Taking several hours to resume would not be ideal unless we could schedule it to be fully resumed by a certain time in the morning (provided we aren't charged for the startup time or else the cost savings would be gone).

    Yes - cost savings is the motivator, so this could be addressed via licensing as well (free dev/qa instances for MSDN subscribers and/or Enterprise customers, etc). Not sure how well smaller vCore instances would work for *this* concern, I would have to see what's possible with it. Could we automate the scale down / scale up the vCores quickly? How much cost would it save scaling them down overnight?

    Thanks

    Brad supported this idea  · 
  3. 7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Brad shared this idea  · 
  4. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all and thank you for your feedback. While this will not directly address backup and restore from MI to back on-premises SQL (this is also being considered and some updates might follow), we are considering a replication technology which might help support this scenario. We are exploring product improvement opportunities in the area of hybrid link using distributed availability groups (AG) replication technology between SQL Server and MI. This will enable near real time data replication between SQL Server and MI. We are also considering failover scenarios both ways. If this might interest you, we invite you to provide your feedback to the engineering team through this online survey: https://aka.ms/mipg-chimera-survey. Thank you.

    Brad supported this idea  · 
    An error occurred while saving the comment
    Brad commented  · 

    Our use case for this request would be to be able to restore an archived backup of a database from within the past 3-7 years to be able to answer auditing questions. We would prefer not to have to create a new managed instance for this. Transaction replication would not work, BACPAC might work but is not ideal.

  5. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    LTR (Long Term Retention) backup for Managed Instance is being worked on and should be expected in a preview in calendar year 2020. Updates will follow when the feature becomes available.

    Brad supported this idea  · 
  6. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Brad supported this idea  · 
  7. 56 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Brad supported this idea  · 
  8. 40 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Brad supported this idea  · 
  9. 115 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Brad supported this idea  · 

Feedback and Knowledge Base