>I want make a program to backup a database, can someone tell me how can i do this, the problem is that when the database is open i do not know how to zip it without closing the database

At a company I used to work at... we had a program running on a computer that did a "select * into table" for a backup - we had a bad problem with our power and ran it every few hours.