does this backup the database?

@macgig

Yes, your database/sql is in the backup.

thank you.

A question on the database inclusion in the backup.
Are user defined tables that i create in the database exported as well?

@wimjanse
Only if they have the wpdb->prefix (the default one is wp_)