BackUp a database using query in SQL 2005

Query Syntax

Backup database [database name] to disk=’path to store the file’

Example

Backup database xyz to disk ='c:\data_backup'

While taking backup you can also view the progress status

Query

Backup database [database name] to disk=’path to store the file’ with stats=30

here 30 will show you

30 percent processed
60 percent processed