How to take the backup of live sql server 2005 express DB

Question

How to take the backup of live sql server 2005 express DB ? At any given time some transaction are in progress.

Answer 1

BACKUP DATABASE does this:

SQL Server uses an online backup process to allow a database backup while the database is still in use. During a backup, most operations are possible; for example, INSERT, UPDATE, or DELETE statements are allowed during a backup operation.

Operations that cannot run during a database or transaction log backup include:

• File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options.
• Shrink database or shrink file operations. This includes auto-shrink operations.

Answer 2

See How to: Create a Full Database Backup (Transact-SQL).

Answer 3

Refer this msdn link