• Hey,

    I just solved the problem by search Google.

    1. this article might help, http://www.howtogeek.com/50299/batch-script-to-backup-all-your-sql-server-databases/

    2. Or try some third-party software to backup your SQL server 2008.

    I finally decided on backup software to make everything easier for me even I knew a lot of open source can do nice job, too.