This is a followup to the earlier post, Migrating Dentrix Image 4.5’s database to another computer. Please see that post to understand how I got here in the first place.
- Main Dentrix 11 and all DXImage files are running on Windows 2008 Server
- DXImage database is running on Windows XP
- We have a 2-disk RAID NAS in our network
- We also subscribe to an offsite backup service, CrashPlan
- With Dentrix’s internal backup. If you dig deep on the server where your image database is housed, you will see a folder called ViperDataBackup. In our case, this is in \Dentrix\DXImage\MSDE\MSSQL$VIPER\Backup\ViperData . This folder grows with two new files each day:
These files seem to represent nightly backups. We use Cobian Backup on the server to copy all files from this directory to the NAS each night. The main issue, as illustrated below, is that I have no idea how to restore from these files currently.
- With our own scripts. DXImage database is running on Microsoft SQL Server Embedded, in a database called VIPER. We created a script that essentially backs up the VIPER database each night to a file, then copies that file to the NAS. The two main lines of this script are:
osql -S SERVER2\VIPER -E -i SqlFullBackup.sql
copy /Y /Z /V *.* X:\backup\
where SqlFullBackup.sql is as follows:
BACKUP LOG MASTER WITH TRUNCATE_ONLY
BACKUP LOG MODEL WITH TRUNCATE_ONLY
BACKUP LOG MSDB WITH TRUNCATE_ONLY
BACKUP LOG VIPER WITH TRUNCATE_ONLY
BACKUP DATABASE MASTER TO DISK =’C:\backup\MASTER-nightly-backup.bak’
BACKUP DATABASE MODEL TO DISK =’C:\backup\MODEL-nightly-backup.bak’
BACKUP DATABASE MSDB TO DISK =’C:\backup\MSDB-nightly-backup.bak’
BACKUP DATABASE VIPER TO DISK =’C:\backup\VIPER-nightly-backup.bak’
We then backup the entire contents of this c:\backup directory to the NAS.