I made an application for a shop. It got only one database that stores the whole days billing. When a new financial year begins it makes a backup of the existing table in the same database. The size is now increasing like anything.
Can anybody tell me what is the actual process of backup. Should I make an altogether different database to store the backup table ?
What are the options I should keep in mind while working for backup?

Please help.