Hi all. First, I am new to databases in general. I have an installation of Quickbooks POS which utilizes a SQL Anywhere 9 database. Unfortunately, the actual qbpos.db file is corrupted and will not open in the software. I do have a valid backup (about 2 months old) and a valid transaction log. What do I need to do to take the back and log file and merge them into a valid current qbpos.db file? i would welcome any and all help you can all offer.

asked 05 Dec '11, 22:09

MichaelW's gravatar image

MichaelW
61133
accept rate: 0%


This forum is intended for SQL Anywhere database developer questions specifically. While QuickBooks does utilize SQL Anywhere as part of its data store, specific recovery of the Intuit database must be done by Intuit personnel. Intuit has set their application database up with specific security features to discourage end-users from accessing the database directly. As such, Sybase will not be able to directly assist you with recovery of this database.

Please contact Intuit directly and ask about their data recovery services via technical support. See: http://smallbusiness.intuit.com/small-business/support/index.jsp

permanent link

answered 06 Dec '11, 11:21

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Have a look at this guide: Recover from media failure on the data

permanent link

answered 06 Dec '11, 03:48

Martin's gravatar image

Martin
8.6k119151237
accept rate: 14%

edited 06 May '14, 12:24

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275

to prevent this from happening in the future, you can set up a backup event to create copies of the db on a hard drive. then copy the backup to some other media

open the db in Sybase Central and create a new event

this is the sql you need (change the drive letter, folder and day of the week as required )

begin backup database directory 'e:\dbBackup\Wednesday\' end

on the schedule tab, set the day of the week and the time. The command does a full backup. i do one for each day of the week.

if you want to do transaction log backups during the day this is the sql you need.

BEGIN backup database directory 'E:\dbBackup\logs12' transaction log only END

set up the schedule as required

i don't have a running copy of ASA8, so i'm not sure if you can schedule a daily maintenace plan.

permanent link

answered 06 Dec '11, 06:07

Tom%20Mangano's gravatar image

Tom Mangano
632212636
accept rate: 6%

Hi

In order to restore a backup, do the folowing (extracted from the Sybooks):

The following example applies the offline (backup) and current transaction logs to the backup copy of the sample database using the -ad database server option. The database server uses the log offsets in the transaction logs to determine the correct order in which to apply the log files.

0) Copy the original files (corrupted) and backup files to another directory just to have a spare copy of each file (you won't use those files, it's just a precaution).

1) Copy the backup transaction log and current transaction log into a directory. For example, copy the files to c:backuplogs.

2) Start the database server and apply the transaction logs to a backup copy of a database called backupdemo.db:

dbeng12 backupdemo.db -ad c:\backuplogs

The database server applies the transaction logs to the backup copy of the database and then shuts down.

After that, put the database file and transaction log back to the same directory as the original database and restart it.

permanent link

answered 06 Dec '11, 06:59

MarcosCunhaLima's gravatar image

MarcosCunhaLima
3068918
accept rate: 0%

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:

×9

question asked: 05 Dec '11, 22:09

question was seen: 5,503 times

last updated: 04 Nov '16, 01:29