We recently have had missing data from our database in SQL Server 2000. The logs do not show anything, but the main table got records deleted or missing somehow, and it took records out of the other tables. All that was done recently was a backup of the table to a file on the D: drive, and an export from the database to another on another server. The export apparently has the same incomplete data as the database it was imported from.
Before the import the second database was blank. My coworker seems to think that either the backup or export had caused the problem. Is it possible for a backup or export to delete records, and if so, could it only delete from certain tables? Also the relationships mysteriously seemed to have vanished from the tables. Also what could be causing records to go missing?
We have SQL Server 2000 and SP2 installed for SQL Server, and SP3 installed for Windows 2000 Server. The only other time I have seen something like this, was when someone was deleting records without knowing that they where doing by hitting a wrong key. But that was in an Oracle Form, on a different database. This is a test database still being developed. But we have about ten people in the company with access to our Intranet. I doubt any of them would delete records, but I cannot find any log of it. Any ideas?
Any problems with replication, backups, imports/exports, that would cause this to happen? I have ruled out anyone doing a record deletion as the transaction logs do not show any deleted records.
Before the import the second database was blank. My coworker seems to think that either the backup or export had caused the problem. Is it possible for a backup or export to delete records, and if so, could it only delete from certain tables? Also the relationships mysteriously seemed to have vanished from the tables. Also what could be causing records to go missing?
We have SQL Server 2000 and SP2 installed for SQL Server, and SP3 installed for Windows 2000 Server. The only other time I have seen something like this, was when someone was deleting records without knowing that they where doing by hitting a wrong key. But that was in an Oracle Form, on a different database. This is a test database still being developed. But we have about ten people in the company with access to our Intranet. I doubt any of them would delete records, but I cannot find any log of it. Any ideas?
Any problems with replication, backups, imports/exports, that would cause this to happen? I have ruled out anyone doing a record deletion as the transaction logs do not show any deleted records.
