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

开发者_运维问答How to take the backup of live sql server 2005 express DB ? At any given time some transaction are in progress.

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.

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

Refer this msdn link