[HCN] MDW3 - Restore failures

[Peter Machell]

We continue to get the message "This file is not in the HCN backup  
format and cannot be restored" when attempting to use the HCN  
Restore2 GUI on anything but the original machine, when the backup  
has been scripted according to the MD docs. This fails even on a  
clean install on new computers.

We need to resort to OSQL to do the restore after the backup file has  
been unzipped by the user.

Running the batch file below restores the database and the documents.

The user then needs to run the manageezy utility to fix the hostname  
and volume name (although after not a lot of success with this I just  
make the volume name the same on both machines), and sometimes the  
login utility.

Whilst I'm comfortable with doing the below and even have it almost  
automated (can't script the manageezy util or the login fix, can I?),  
this is way more complex than it should be.

Has anyone had similar problems trying to restore and managed to fix it?


regards,
Peter.



@echo off
setlocal
set loc=C:\documents and settings\owner\desktop\restore
echo Restoring database HCN
osql -E -S NOTEBOOK\HCNSYSTEM -Q "RESTORE DATABASE HCN FROM DISK = '% 
loc%\Temp\HcnBackupV2\HCN.BAK'"
echo Restoring database HCN_MNGEZY
osql -E -S NOTEBOOK\HCNSYSTEM -Q "RESTORE DATABASE HCN_MNGEZY FROM  
DISK = '%loc%\Temp\HcnBackupV2\HCN_MNGEZY.BAK'"
echo Copying documents
xcopy /D /E "%loc%\ManageEzy" c:\ManageEzy
echo Finished