# Possible ideas for automating your AyaNova SQL Express backup

**URL:** <https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082>\
**Category:** Backup & Restore\
**Created:** [December 14, 2011, 8:56am UTC](https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082 "2011-12-14T08:56:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AyaNovaSupport](https://forum.ayanova.com/user_avatar/forum.ayanova.com/ayanovasupport/32/229_2.png) [@AyaNovaSupport](https://forum.ayanova.com/u/AyaNovaSupport)\
**Post date:** [December 14, 2011, 8:56am UTC](https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082/1 "2011-12-14T08:56:19Z")

</div>

Hi

I have posted below a number of URL links about possible solutions for automating your SQL Express backup - as SQL Management Studio Express does not include a utility to do so.

Do note that below are provided as a courtesy only, we do not recommend one over the other.

[http://gatekiller.co.uk/Post/Automate\_SQL\_Server\_Express\_Backups](http://gatekiller.co.uk/Post/Automate_SQL_Server_Express_Backups)

[http://www.sqldbatips.com/showarticle.asp?ID=27](http://www.sqldbatips.com/showarticle.asp?ID=27)

[http://www.fmsinc.com/free/NewTips/SQL/SQLServerExpressDatabase/Automated\_Backup.asp](http://www.fmsinc.com/free/NewTips/SQL/SQLServerExpressDatabase/Automated_Backup.asp)

[http://support.microsoft.com/kb/2019698](http://support.microsoft.com/kb/2019698)

You can also yourself just do a search online for more results and solutions too!

---

<div class="post-metadata">

**Author:** ![system](https://forum.ayanova.com/letter_avatar_proxy/v4/letter/s/bcef8e/32.png) [@system](https://forum.ayanova.com/u/system)\
**Post date:** [January 10, 2012, 1:22am UTC](https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082/2 "2012-01-10T01:22:10Z")

</div>

Hi,

I use a free app called sql backup and ftp, this works well and is free for single database backups

[http://sqlbackupandftp.com/](http://sqlbackupandftp.com/)

Cheers

Chris

---

<div class="post-metadata">

**Author:** ![AyaNovaSupport](https://forum.ayanova.com/user_avatar/forum.ayanova.com/ayanovasupport/32/229_2.png) [@AyaNovaSupport](https://forum.ayanova.com/u/AyaNovaSupport)\
**Post date:** [January 10, 2012, 8:39am UTC](https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082/3 "2012-01-10T08:39:28Z")

</div>

Thank you Chris - always great to hear about what is in use!

- Joyce

---

<div class="post-metadata">

**Author:** ![AyaNovaSupport](https://forum.ayanova.com/user_avatar/forum.ayanova.com/ayanovasupport/32/229_2.png) [@AyaNovaSupport](https://forum.ayanova.com/u/AyaNovaSupport)\
**Post date:** [March 18, 2015, 3:39pm UTC](https://forum.ayanova.com/t/possible-ideas-for-automating-your-ayanova-sql-express-backup/2082/4 "2015-03-18T15:39:09Z")

</div>

Wanted to pass on another SQL backup utility that is compatible with SQL AND available FREE if your SQL Server has no more than 2 SQL databases -

[http://www.sqlmanager.net/en/products/mssql/sqlbackup](http://www.sqlmanager.net/en/products/mssql/sqlbackup)