Backup & Recovery for SQL Server configuration

Top Previous Next

SQL 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.

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

Backup using SQL Server's Enterprise Manager

You can use SQL Server's Enterprise Manager program to automate backup of the SQL Addressinator! database.

Here are the basic steps to backup up a SQL database - please refer to SQL Server's Help files for details:

1.	Select Start>>Programs>>Microsoft SQL Server>>Enterprise Manager. The SQL Server Enterprise Manager window appears.

2.	Expand Console Root until you locate the correct Addressinator! database on the server.

3.	Right-click on the database name. From the local menu, select All Tasks>>Backup Database. The SQL Server Backup dialog box appears.

4.	Type the Database and Name, if they are different from what is automatically applied. You can then specify the database location, and set a schedule for regular backups.

Click Help in Enterprise Manager, for specific information on SQL backup settings.