If you use SQL Server 2005, then do this:
- Go to your database and right click on the database name.
- Go to Task and choose Backup and Enter, your backup is created.
Then if you want to restore it:
- Make a new database and right click.
- Choose Restore database and choose Backfile.
- Select file name and restore it.
