Backing up using SQL Server

You must use SQL Server approved backup and restore utilities only.

You can not copy a SQL Server database file to a backup device, and restore that file, and be able to successfully access the restored database.

Microsoft provides SQL Server Management Express which can be used for backup and restore of a SQL Express database. Refer to Microsoft website to download and for instructions on use. Example location may be http://msdn.microsoft.com/vstudio/express/sql/

You may also want to investigate using a 3rd party tool for performing management and administrative tasks such as scheduling database backups.

This section lists just a few of the 3rd party tools that are available. We do not endorse or recommend these products. We are simply giving you a starting point for investigating some of the available tools.

MSDE Manager

http://www.valesoftware.com/products-msde-manager.php

Teratrax Database Manager

http://www.teratrax.com/tdm30/index.html

SQL Express Tools

http://www.sqlexpresstools.com/

Database administrative functions can also be accomplished without 3rd party tools by using the osql.exe utility that is installed with MSDE.  Refer to the link to learn about using osql to administer MSDE: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_adminovw_7f3m.asp

It is recommended to test your backup and restore before you need it.