Dear Experts,

I am new in Sybase I am installed SAP BusinessObjects 4.1 during installation it's create databse which is Sybase SQL anywhere 12 Database ( First time I use it ). I am trying to login in database but unable then I found and installed SQL anywhere12 client which include Sybase Central Admin tool I lgoin and take Create backup image ( Tools --- > Create Backup Image ) it's create two file in backup folder BI4_CMC.db and BI4_CMC.log ( before taken backup I stop the service of Database from Windows Services ) then I delete BI4_CMC.db from actual database path ( c:\Program Files (x86)\BusinessObjects\sqlanywhere\database ) then try to start database but unable to start then I goto sybase Central admin tool ( Tools --> restore database ) its ask about Where is the archive you want to restore ? I gave backup folder path and BI4_CMC.db then it asked about what is the directory and path name where you want to restore the main database file ? I gave c:Program Files (x86)\BusinessObjects\sqlanywhere\database\BI_CMC.db after that

RESTORE DATABASE 'c:\Program Files (x86)\BusinessObjects\sqlanywhere\database\BI4_CMC.db' FROM 'c:\SQLanywhereBackup\BI4_CMC.db' I press Finsh Button it gave me error

The Database archive 'c:\SQLanywhereBackup\BI4_CMC.db' Could not be restored on the Server' _sc739059084'.
Error During backup/restore: Unable to open device 'c:\SQLanywhereBackup\BI4_CMC.db' (unknown error status HDR lables)
SQLCODE -697
SQLSTATE HY000
SQL statement  RESTORE DATABASE 'c:\Program Files (x86)\BusinessObjects\sqlanywhere\database\BI4_CMC.db' FROM 
'c:\SQLanywhereBackup\BI4_CMC.db'

Regards

asked 03 Nov '13, 03:03

shahidranazai's gravatar image

shahidranazai
60223
accept rate: 0%

edited 03 Nov '13, 07:25

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844


The file 'c:\SQLanywhereBackup\BI4_CMC.db' is probably an image backup rather than an archive backup and you can only use the RESTORE DATABASE statement for archive backups.

An image backup is much easier to restore: You just do a file copy to the folder where you want it run it, along with the 'c:\SQLanywhereBackup\BI4_CMC.log', and start the server. No special statement is required to "restore" an image backup because it is a usable database file itself.

permanent link

answered 03 Nov '13, 07:32

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844
accept rate: 20%

Thankx a lot Breck for guidance, I also taken backup from Sybase Cental Tool database backup when I restore it its resotr but when I start database ( service from windows ) datbase not start

I don't how to find the log what is the problem not erro shown in restore but I can not find resore logs or message.

regards

(03 Nov '13, 09:39) shahidranazai
Replies hidden

There should be something in the Windows Application Log if the service can't start. If you don't understand what it says, please post it here.

(04 Nov '13, 04:36) Justin Willey

You might want to configure the database engine to write a log file. This will help to analyze why the DB couldn't be started. Example:

-o C:\Temp\SA12log.txt
-os 2M
-oe C:\temp\SA12err.txt

(04 Nov '13, 08:13) Reimer Pods
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×14

question asked: 03 Nov '13, 03:03

question was seen: 2,331 times

last updated: 04 Nov '13, 08:14