# Database dump with mssql\_db module

**URL:** <https://forum.ansible.com/t/database-dump-with-mssql-db-module/25227>\
**Category:** Ansible Project\
**Created:** [August 10, 2017, 9:23pm UTC](https://forum.ansible.com/t/database-dump-with-mssql-db-module/25227 "2017-08-10T21:23:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gilberto\_Valentin](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@Gilberto\_Valentin](https://forum.ansible.com/u/Gilberto_Valentin)\
**Post date:** [August 10, 2017, 9:23pm UTC](https://forum.ansible.com/t/database-dump-with-mssql-db-module/25227/1 "2017-08-10T21:23:54Z")

</div>

I am curious to see what you are all doing to do DB dumps of MSSQL schema’s using Ansible. Looking at the **mssql\_db** module, the only option I see is for importing. What is everyone else doing to get some backups via Ansible?

---

<div class="post-metadata">

**Author:** ![Kai\_Stian\_Olstad](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@Kai\_Stian\_Olstad](https://forum.ansible.com/u/Kai_Stian_Olstad)\
**Post date:** [August 14, 2017, 9:53pm UTC](https://forum.ansible.com/t/database-dump-with-mssql-db-module/25227/2 "2017-08-14T21:53:07Z")

</div>

I push out a script with copy module that does the backup, and create a cron job with the cron module that runs every day.