how to create backup of my database in SQL Server

How to create back of my database which is made in SQL Server Express edition?

开发者_C百科

I want to create backup and restore it how could this do please tell me

---

Use the BACKUP command.

For example:

BACKUP DATABASE AdventureWorks2008R2
TO DISK='Z:\SQLServerBackups\AdvWorksData.bak' 
WITH FORMAT