Bagaimana mengatur backup dan long-term retention policy untuk Azure Database menggunakan Azure Backup dan Recovery Services Vault

Question

Bagaimana mengatur backup dan long-term retention policy untuk Azure Database menggunakan Azure Backup dan Recovery Services Vault

Bambang Wasminto 0

Bagaimana kita mengatur backup dan long-term retention policy untuk Azure Database menggunakan Azure Backup dan Recovery Services Vault? mohon bantuannya, supaya mudah difahami...

Bambang Wasminto 0 Reputation points

2025-05-18T04:46:22.31+00:00

Untuk database PaaS (Azure SQL Database), LTR dikonfigurasi langsung dari database settings dan backup disimpan otomatis. Untuk IaaS SQL Server, gunakan Recovery Services Vault dengan backup policy yang fleksibel. Keduanya mendukung retensi hingga 10 tahun dan memungkinkan restore terkontrol.
Bambang Wasminto 0 Reputation points

2025-05-18T04:47:56.77+00:00
Untuk mengatur backup dan kebijakan retensi jangka panjang (Long-Term Retention / LTR) pada Azure SQL Database menggunakan Azure Backup dan Recovery Services Vault, berikut langkah-langkah dan penjelasannya:

🔹 1. Memahami Skema Backup Azure SQL Database

Azure SQL Database secara default memiliki mekanisme automated backup yang menyimpan:

Point-in-time restore selama 7 hingga 35 hari (tergantung edisi database).

Backup tersimpan secara **geo-redundant** atau **locally-redundant**, tergantung konfigurasi. Namun, untuk **retensi jangka panjang** (bulan/tahun), kita perlu menggunakan **Long-Term Retention (LTR)**.

🔹 2. Menggunakan Long-Term Retention (LTR)

LTR memungkinkan Anda menyimpan full backup mingguan dalam jangka panjang:

Maksimal:

Hingga 10 tahun

Dengan frekuensi: **mingguan, bulanan, tahunan**

✅ Cara konfigurasi LTR:

Masuk ke portal Azure.

Navigasi ke SQL Database atau SQL Server tempat database Anda berada.

Pilih tab "Manage Backups" atau cari menu "Long-term backup retention".

Pilih database dan klik Configure Retention.

Atur kebijakan retensi, contoh:

Weekly backup: keep for 12 weeks

Monthly backup: keep for 12 months Yearly backup: keep for 5 years Simpan pengaturan. Backup akan disimpan ke **Recovery Services Vault** secara otomatis.

🔹 3. Menggunakan Recovery Services Vault (RSV)

Untuk Azure SQL in VM (SQL Server running in an IaaS VM), RSV digunakan lebih langsung:

Buat Recovery Services Vault di resource group dan region yang sama.

Daftarkan VM yang berisi SQL Server.

Install Azure Backup agent / Azure VM extension jika diminta.

Pilih workload type: SQL Server in Azure VM.

Pilih database yang akan di-backup.

Buat dan terapkan Backup Policy:

Daily/Weekly backup schedule

Retention: daily (30 hari), weekly (52 minggu), monthly (60 bulan), yearly (10 tahun). Monitor backup dan restore melalui tab **Backup Jobs** dan **Backup Items**.

🔹 4. Restore Opsi yang Didukung

Point-in-time restore (PITR) untuk operational restore.

LTR restore memungkinkan memilih full backup mingguan yang disimpan hingga bertahun-tahun.

Restore dapat diarahkan ke:

Server yang sama

Server berbeda Resource group lain (jika diizinkan)

🔹 5. Best Practice

Selalu uji restore secara berkala.

Gunakan naming convention pada backup untuk memudahkan identifikasi.

Terapkan role-based access control (RBAC) untuk membatasi siapa yang bisa melakukan restore/delete.

Pastikan backup terenkripsi dan tersimpan di region sesuai compliance (misalnya GDPR, ISO, HIPAA).Untuk mengatur backup dan kebijakan retensi jangka panjang (Long-Term Retention / LTR) pada Azure SQL Database menggunakan Azure Backup dan Recovery Services Vault, berikut langkah-langkah dan penjelasannya: 🔹 1. Memahami Skema Backup Azure SQL Database

Azure SQL Database secara default memiliki mekanisme automated backup yang menyimpan:

Point-in-time restore selama 7 hingga 35 hari (tergantung edisi database).

Backup tersimpan secara geo-redundant atau locally-redundant, tergantung konfigurasi.

Namun, untuk retensi jangka panjang (bulan/tahun), kita perlu menggunakan Long-Term Retention (LTR).

🔹 2. Menggunakan Long-Term Retention (LTR) LTR memungkinkan Anda menyimpan full backup mingguan dalam jangka panjang:

Maksimal:

Hingga 10 tahun

Dengan frekuensi: mingguan, bulanan, tahunan

✅ Cara konfigurasi LTR:

Masuk ke portal Azure.

Navigasi ke SQL Database atau SQL Server tempat database Anda berada.

Pilih tab "Manage Backups" atau cari menu "Long-term backup retention".

Pilih database dan klik Configure Retention.

Atur kebijakan retensi, contoh:

Weekly backup: keep for 12 weeks

Monthly backup: keep for 12 months

Yearly backup: keep for 5 years

Simpan pengaturan. Backup akan disimpan ke Recovery Services Vault secara otomatis.

🔹 3. Menggunakan Recovery Services Vault (RSV) Untuk Azure SQL in VM (SQL Server running in an IaaS VM), RSV digunakan lebih langsung:

Buat Recovery Services Vault di resource group dan region yang sama.

Daftarkan VM yang berisi SQL Server.

Install Azure Backup agent / Azure VM extension jika diminta.

Pilih workload type: SQL Server in Azure VM.

Pilih database yang akan di-backup.

Buat dan terapkan Backup Policy:

Daily/Weekly backup schedule

Retention: daily (30 hari), weekly (52 minggu), monthly (60 bulan), yearly (10 tahun).

Monitor backup dan restore melalui tab Backup Jobs dan Backup Items.

🔹 4. Restore Opsi yang Didukung

Point-in-time restore (PITR) untuk operational restore.

LTR restore memungkinkan memilih full backup mingguan yang disimpan hingga bertahun-tahun.

Restore dapat diarahkan ke:

Server yang sama

Server berbeda

Resource group lain (jika diizinkan)

🔹 5. Best Practice

Selalu uji restore secara berkala.

Gunakan naming convention pada backup untuk memudahkan identifikasi.

Terapkan role-based access control (RBAC) untuk membatasi siapa yang bisa melakukan restore/delete.

Pastikan backup terenkripsi dan tersimpan di region sesuai compliance (misalnya GDPR, ISO, HIPAA).
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-19T03:38:14.6+00:00

Hi Bambang Wasminto

Greeting!

Yes, your documentation is correct, and it provides clear steps.

Please let me know if you face any issues during configuration.

Could you please share additional details that I requested via private message for a remote session?
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-20T04:43:34.1766667+00:00

Hi Bambang Wasminto

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-21T03:00:41.83+00:00

Hi Bambang Wasminto

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Bambang Wasminto 0 Reputation points

2025-05-18T04:46:22.31+00:00

Untuk database PaaS (Azure SQL Database), LTR dikonfigurasi langsung dari database settings dan backup disimpan otomatis. Untuk IaaS SQL Server, gunakan Recovery Services Vault dengan backup policy yang fleksibel. Keduanya mendukung retensi hingga 10 tahun dan memungkinkan restore terkontrol.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-19T03:38:14.6+00:00

Hi Bambang Wasminto

Greeting!

Yes, your documentation is correct, and it provides clear steps.

Please let me know if you face any issues during configuration.

Could you please share additional details that I requested via private message for a remote session?
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-20T04:43:34.1766667+00:00

Hi Bambang Wasminto

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-05-21T03:00:41.83+00:00

Hi Bambang Wasminto

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi Bambang Wasminto,

Long-Term Retention (LTR) helps you keep backups for an extended period—up to 10 years—for safety, legal, or business reasons. It is built into Azure SQL, so you don’t need to use Azure Backup Vault separately. Azure automatically takes backups of your database, and LTR saves some of these backups for a longer time based on your chosen retention settings. You can decide how many weekly, monthly, and yearly backups to keep, such as 12 weeks, 12 months, or 10 years respectively. These backups are stored securely in Azure and do not affect your database performance. You can restore your database from these backups anytime you need. Even if you delete the database or server, the LTR backups remain safe. You can easily set up and manage LTR using the Azure Portal, PowerShell, or CLI.

Kindly refer to the document below:
https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql-db&preserve-view=true&tabs=portal

Share via

Bagaimana mengatur backup dan long-term retention policy untuk Azure Database menggunakan Azure Backup dan Recovery Services Vault

1 answer

Your answer