SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-02-19 20:57:33

amoyes
Member

History not showing up

I'm trying to recover some queries that I lost. (Yes, I know I should have saved them.) I have several questions/issues:

1. The SQL History doesn't show the latest history. For example, the latest entry today is from 01/30/14 and I've run a bunch of queries since then.
2. The SQLExecuteHistory.xml file doesn't list all of the queries I've recently run.
3. The SqlDbx directory with the backup, logs, results, and scripts folders don't contain anything. Should these be empty?
4. Does SqlDbx create an temp files? If so, where would they be located? I've tried to find any but have not been able to.
5. I just turned on logging today after this incident but this won't help me recover the old files.

Background: I typically have multiple SQLDbx windows open at a time, connected to Sybase and Oracle databases. I leave these open for days and just reconnect to run a new query. I'm just a user and don't have any administrative level access or privileges. I use SqlDbx pro v3.43.

I hope there is a way to recover these lost queries. Someone please help!

Offline

#2 2014-02-20 10:07:10

sqldbxhelp
Administrator

Re: History not showing up

1. That is strange. History should show last 128 queries you executed
2. SQLExecuteHistory.xml lists only queries visible in History.
3. By default backup is not enabled.
4. No
5. Unfortunately that is correct.

Offline

Board footer

Powered by FluxBB