Backing up your Database
From DLS5 Wiki
Revision as of 01:54, 14 July 2009 by Robmatthews (Talk | contribs)
Performing a routine backup of your valuable customer accounts is a great idea. DLS IV stores all accounts in an SQL database, so there are a number of tools available to maintain your database.
We recommend using Microsoft SQL Management Studio Express 2005.
- Get SQL Management Studio Express 2005 (free) here
Install Microsoft SQL Management Studio Express 2005 and use "Windows Authentication" to connect to your SQLEXPRESS instance. There will be a DLSPRONET database active and online in your instance of SQL Express.
- Right-click the DLSPRONET database and select "Tasks" - "Backup"
- Set the backup options as follows:
- Backup Database = DLSPRONET
- Backup Type = Full
- Backup Expiry = none
- Backup Location - click ADD to select the location where your DLSPRONET.BAK file will be placed
- Click OK to begin the backup process. Watch the progress in the bottom left corner
Note: the Security Stamp is recorded with the database when it is backed up. In order to restore this database in the future, you will need to know the Security Stamp. Please record your Security Stamp in a safe place.