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'
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.
answered 03 Nov '13, 07:32