Why do you want to create the backup on a flat file, use SQL native backup tool and take the backup.

If you have to backup all tables on flat files, then you might have to do it for every table seperately.

You can use Export data / bcp / SSIS package etc.

Pavan.