SQL Server Performance Forum – Threads Archive
Sudden Disappearing of SQL Server Data
Hi there,I am using an SQL Server database with VB as user interface.
I have about 17 users accessing the Database at the same time.
The Databse is located on the server.
Sometimes, and not always, after saving some data and printing them on papers, these data are lost and no trace is found for it.
Even in the transaction log file, nothing is found concerning this data.
Some told me that the Indexes maybe the cause.
What makes it mysterious, is that this problem does not always happen. I wonder if someone has an idea about this problem and can provide some help.
Thank you.
can not be the problem with indexes.
use third party tool like red gate log rescue to catch who delete those data —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
How do you know that data disappeared? Did you try to find data using application or direct queries (from query analyzer)? Are you sure they are really written? When you print them on papers, are you sure they are saved? It could be they are written from apps memory structure. Have you run trace to see what happens when suspect operation is performed?
First I tried to find data using application, when not found i used query analyzer.
The data is surely saved and printed.
I tried to search in the transaction log file, but found nothing about this data.
What do yuo mean by apps memory structure?
How do you manage to search the transaction log file for data? Please explain:
First I tried to find data using application, when not found i used query analyzer.
The data is surely saved and printed. Do you mean that you found the data in query analyzer, but not in the application? Then the problem is most likely at the application end of things.
Even in the transaction log file, nothing is found concerning this data.
How you were able to read Transaction log?
Do you have any third party tool to do so?
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Run this and check whether you get results Select object_name(id), rows from sysindexes where indid<2 and rows>0 order by 1
Madhivanan Failing to plan is Planning to fail
After a while (several logs in to the application) since saving and printing this data, i couln’t find it again neither from the application nor from query analyzer.
I have searched the Transaction Log file using a function that reads from the Transaction Log file and inserts its contents to a specific table. In this search no trace for deleting this data was found.
quote:What do yuo mean by apps memory structure?
I mean: User pressed saved button and after that while data where still on the screen or somewhere in application structure (array or something like that) he printed data. If that’s the case you first have to make sure that save operation really happened, second check if it was successfull. It may happen that there is no proper error handling in app code, so operation is attempted but data are actually not saved. It would be helpfull if you have access to app code. You can also run a trace to identify the query executed by the operation.After executing this query : Select object_name(id), rows from sysindexes where indid<2 and rows>0 order by 1 i have received 2 columns: In the first column (table name) and in the second (numbers).
What can i deduce from this query ?
I thought you said data are missing
Running that will show you which table has records Madhivanan Failing to plan is Planning to fail
quote:
Running that will show you which table has records I don’t mean that the whole table data is lost, but after saving some data, this data was lost.
It might sound obvious, but no data simply "disappears". You can rule out indexes as a reason. They certainly aren’t the cause of your trouble. I would start by inspecting the front-end and how it is saving data. And interviewing the user. Have you verified yourself that once saved data is gone or did some user swear he saved it and now it’s gone? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
]]>