![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have problem when Archive/Restore Database file, I use "BACKUP DATABASE TO" for Archive DB and use "RESTORE DATABASE " for restore DB. I archive database from Server and then restore database at my PC, I have no problem when restore. Here's the problem when I try to connect database I got error . Unable to start specified database: C:\Apps\Test1.log: transaction log file not found [Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: C:\Apps\Test1.log: transaction log file not found Error code=-82 SQL state=08001 Directory C:\Apps is on Server and when I restore database file on my PC I keep it in C:\DBTest and when I try to connect database form my PC (C:\DBTest\Test1.db) the error occur. Please help, I hope you understand my English because I'm not good at all. Thank you, BonWan |
#3
| |||
| |||
|
|
The server is looking for the log file. You have to set the location/name of the log file with the dblog utility: dblog -t logfilename. Regards Arthur -- BonWan wrote: I have problem when Archive/Restore Database file, I use "BACKUP DATABASE TO" for Archive DB and use "RESTORE DATABASE " for restore DB. I archive database from Server and then restore database at my PC, I have no problem when restore. Here's the problem when I try to connect database I got error . Unable to start specified database: C:\Apps\Test1.log: transaction log file not found [Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: C:\Apps\Test1.log: transaction log file not found Error code=-82 SQL state=08001 Directory C:\Apps is on Server and when I restore database file on my PC I keep it in C:\DBTest and when I try to connect database form my PC (C:\DBTest\Test1.db) the error occur. Please help, I hope you understand my English because I'm not good at all. Thank you, BonWan |
![]() |
| Thread Tools | |
| Display Modes | |
| |