Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-18 : 08:57:23
|
| Alex Dshalalow writes "Dear Sir/Madam,Thank you for your time in evaluating my question.We have software that runs in our company. This program's backend database is in MSSQL2000.We have a maintainance plan, which backs up the database every hour and keeps backups up to a week.At random times throughout the day, arbitrary files are completely emptied. This has happened already 3 times, on 3 different files (not all at once, but each occurance a few days apart).We were able to recover most of the data through backups and paperwork, but it took hours, and we had to cut off production while we were working on restoring these files.What is happening? What could possibly cause this? Our suspicion is this: we run hourly backups (automated from the maintainance plan). While the backups are run, the system is live, with the front-end program being used and data being entered. Could the backup during live transactions cause certain files to be emptied?Please advise - your help would be most appreciated!Thanks,Alex Dshalalow" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-18 : 09:43:15
|
| "Could the backup during live transactions cause certain files to be emptied?"No.Most likely is that something is deliberately (although perhaps as a result of a bug) emptying the tables.It is possible to user 3rd party tools to examine the log files to see exactly what happened, or there are tools to enabled SQL Server activity to be monitored - but you'd have to wait for it to happen again. (Either of those is a job for a skilled person)Kristen |
 |
|
|
|
|
|
MSSQL2000 emptying files.