I have an act! installed. I have a zip file in which I have a backup file(.bak)
I need to write a script to restore data from .bak to .adf and .alf
I need to restore data to sql server. Need to write the script.
First of all I tried to write a sql script to restore data. But I am not able to restore data using that script.
I have a zip file in which I have the .bak file
So script that I have written is
RESTORE DATABASE demoDatabse FROM DISK='"C:\actdatabases\Backup\database.bak"
But using this script I am only able to restore data that has .mfd extension not adf extension
When I try to restore the database inside the zip file I get this exception.
{"Directory lookup for the file "V:\ACT\ARAMaster.ADF" failed with the operating system error 3(The system cannot find the path specified.).\r\nFile 'ACT_DATA' cannot be restored to 'V:\ACT\ARAMaster.ADF'. Use WITH MOVE to identify a valid location for the file.\r\nDirectory lookup for the file "V:\ACT\ARAMaster.ALF" failed with the operating system error 3(The system cannot find the path specified.).\r\nFile 'ACT_LOG' cannot be restored to 'V:\ACT\ARAMaster.ALF'. Use WITH MOVE to identify a valid location for the file.\r\nProblems were identified while planning for the RESTORE statement. Previous messages provide details.\r\nRESTORE DATABASE is terminating abnormally."}
Dont know ehy this issue is coming and I don't have any dirive as V drive.
Please help me with this. I really need to figure this out.
Also I tried to folow the steps mentioned on http://kb.swiftpage.com/app/answers/detail/a_id/27607
So I wrote the following command to Restore As SQL .BAK backup file
ACTDiag RestoreAs act2011demoNew C:\actdatabases\Backup\database.bak c:\ActDatabases
But again the exception is coming.
Need Help!
Thanks