Backup & Recovery for SQL Express configuration

SQL Express Server database files can not be directly copied. Doing so will corrupt your database. You must use SQL Server approved backup and restore utilities only.

Microsoft provides SQL Server Management Express which can be used for manual 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/

Do note that SQL Server Management Express does not have an automatic backup routine that can be set up. The backup must be performed manually each time.

If you are interested in automating the backup, it is suggested to search the Internet for automatic backup software specifically for SQL Express. Or search the Internet for information on writing your own script to automate database maintenance on a SQL Express database.

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/

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