dbTalk Databases Forums  

Can't find transaction log when try to connect database from restore database file(Server-Side Backup and then restore it in my PC.)

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Can't find transaction log when try to connect database from restore database file(Server-Side Backup and then restore it in my PC.) in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
BonWan
 
Posts: n/a

Default Can't find transaction log when try to connect database from restore database file(Server-Side Backup and then restore it in my PC.) - 01-08-2010 , 02:29 AM






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

Reply With Quote
  #2  
Old   
Arthur Hefti
 
Posts: n/a

Default Re: Can't find transaction log when try to connect database from restore database file(Server-Side Backup and then restore it in my PC.) - 01-08-2010 , 03:24 AM






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:

Quote:
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

Reply With Quote
  #3  
Old   
BonWan
 
Posts: n/a

Default Re: Can't find transaction log when try to connect database from restore database file(Server-Side Backup and then restore it in my PC.) - 01-08-2010 , 06:01 AM



Thank you very much.

Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.