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 - 2003-04-16 : 07:39:15
|
| Mohammad writes "Once every period of time, the database tables in SQL Server 2000 loses most of the data. The tables become empty and so, I've to restore the database from the backup everytime this happens. What should I do to stop this loss of data? I also want to ask how to read the .ldf files containing the log of all transactions performed on the database?Thanks in advance.Regards," |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-04-16 : 07:48:07
|
| This sounds quite worrying. Something must be causing your data to delete, be it a task, scheduled stored procedure, trigger or crazy programmer. Does it always happen at exactly the same time ? You need to establish what the cause is. Without seeing your database it could be a number of things.There is a third party tool for reading log files called something almost like Lumigent - nope can't be sure. Search this site and you'll find the answer though.===========Paul |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-16 : 07:49:12
|
| Tables will become empty because something has deleted the data.Another option is that you have a single connection which is not committing a transaction - this will eventually fail and rollback. The data was never really there and only available to queries which read dirty dta or the connection with the transaction.To look at the transaction log you can buy an application from lumigent.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-16 : 07:51:39
|
| It might be worthwhile running the profiler to log commands to see what is happenning.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Tables lose data!