![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: SAEM - Restore not working Topic Summary: Created On: 22-Sep-2008 13:31 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
We are currently running 10.1 and I am about to set up some test encyclopaedias for a final test of installation scripts before upgrade to version 11.
When I try to restore to a new encyclopaedia using "recover from file" I get a message: Cannot open backup device 'C:\JS_Applications_db_200809220200.bak'. Device error or device off-line. See the SQL Server error log for more details. RESTORE FILELIST is terminating abnormally. Code: -2147218303 When I use the restore function I get The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Code: -2147221262 I have tried this both with a previously undefined encycloapedia and to restore an existing one and the failures are consistent. Without any SQL Server background it isn't clear to me if there is an SA issue here or if it is something that I should pass over to the DBA. |
|
![]() |
|
![]() |
|
Solved it. I don't know if the root cause is down to SAEM or some configuration issue on out network but if anybody else has the problem:
When doing a "Restore from file" the SAEM GUI will browse the client PC drive mappings to select the .bak file. When it runs it looks for that drive mapping on the server. The work around that I used was to mirror the server path on the same drive letter on the PC (luckily unused) and place a copy of the .bak in the mirror location. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.