Data disappearing after nightly backup

[bamundsen]

Hello:

Windows 2000 Server/SQL Server 2000

Two nights ago I noticed that data was disappearing from our ORDERS table after our nightly backup routine. We have approximatley 60000 records in the table. After the backup, all records from 1 - 55600 have been deleted. I have looked through log files and cannot find the problem. Anyone have any ideas??

Thank you,

Brett

 

[ptheriault]

Have you every hear of Lumigent's Log explorer? I would download that and read your log file. If it is a delete statement then you will be able to get your data back and you will also find the process that is deleting the data. I have never seen the backup database command selectivly delete data. It's very likely that there is some process or scheduled task that you don't know about removing the data. Log Explorer will find that for you. It's a very usefull tool.

 

[Catadmin]

Backups shouldn't delete data from tables. The only scenario (other than another process like ptheriault mentioned) is if you've got a Truncate issue where a transaction has not yet committed and you're truncating the DB & Log as a step of the backup right before the actual backup. That might roll back the transaction and then delete the info from the log.





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"