The Dev Hound database is located in one file called devhound.tdbd (if the default database is used: see notes). This file can be backed up by:
Note: By default Dev Hound performs an automatic backup each day (this is configured in default settings). A backup file for each day of the week is kept and each month of the year. This way you should always have a backup for at least a week and a history of backups for the year. It is also important that the backups are kept offsite.
For SQL Server database the filename will depend on the SQL Server setup however will generally be called devhound.mdf and located in the data folder of the installation. If you have created multiple databases the filename will change according to the name you gave to the database. Also note that whilst Dev Hound will attempt to backup this file it may not succeed as the SQL Server database may be in use at the time. For backups it is recommended that a dedicated database backup tool be used (such as the Microsoft Backup tool that comes with Windows XP)
Backup History
To show the history of backups completed:
Your database can be restored by replacing the devhound.tdbd file located in the data directory. You may use one of the automatic backups. It is advisable that you shut down your web server before restoring to prevent anyone from interfering with the restore procedure
- Click on the Admin tab
- Click the Backup Database link
- The database will be backed up to two different files. One with the weekday and one with the month. For example devhound.tdbd.backup_friday, devhound.tdbd.backup_july
Note: By default Dev Hound performs an automatic backup each day (this is configured in default settings). A backup file for each day of the week is kept and each month of the year. This way you should always have a backup for at least a week and a history of backups for the year. It is also important that the backups are kept offsite.
For SQL Server database the filename will depend on the SQL Server setup however will generally be called devhound.mdf and located in the data folder of the installation. If you have created multiple databases the filename will change according to the name you gave to the database. Also note that whilst Dev Hound will attempt to backup this file it may not succeed as the SQL Server database may be in use at the time. For backups it is recommended that a dedicated database backup tool be used (such as the Microsoft Backup tool that comes with Windows XP)
Backup History
To show the history of backups completed:
- Click on the Admin tab
- Click on the Backup History link
- You will be shown a list of backups completed with the date and time they have been completed
Database Restore
Your database can be restored by replacing the devhound.tdbd file located in the data directory. You may use one of the automatic backups. It is advisable that you shut down your web server before restoring to prevent anyone from interfering with the restore procedure