Save configuration of unused SQL servers on Azure to restore later

Greg Vogel 21 Reputation points
2022-09-28T16:12:32.167+00:00

We have two SQL servers we rarely use, but were a pain to set up. Is there any way to back them up to be able to restore them at a later date, and delete the current instances. We are paying around $500 per month for these unnecessarily.

Thank you,

Greg

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Shivam Kumar 541 Reputation points
    2022-09-28T20:46:57.537+00:00

    You might be interested in looking for ARM templates and also for SQL server configuration.ini file in setup bootstrap folder of sql server.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
    2022-09-30T17:01:13.623+00:00

    Hi @Greg Vogel Thank you for posting your question on Microsoft Q&A and for using Azure Services.

    As per my understanding you are looking to back up Azure SQL servers and restore them later. Let me clarify this, a server is a logical concept, there is nothing to back up.
    If you are asking how to create a backup in Azure SQL DB. The answer is you don't need to because it is unnecessary - The system does it automatically. The backup page in the Azure portal let you configure retention for existing backups that the system creates. Please refer to this documentation article Automated backups in Azure SQL Database

    Please let me know if you need additional clarification

    Regards,
    Oury

    1 person found this answer helpful.