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 |
|
learntsql
524 Posts |
 Posted - 2009-11-27 : 07:54:00
|
| Hi All,yesterday There have been some transactions done through front end(.Net) application successfully and we generated some reports too.But today those transactions are missing(Only Yesterday's) from my database(SQL 2000).How to trace/get back those transactions. I tried in following cases:1.I took Full BackUp2.tried to restore as point in time in SQL 2005 but unable to restore.TIA.... |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-11-27 : 08:55:59
|
| What have you tried restore a nightly backup (if you have one) to check if there are still present |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-11-27 : 08:56:44
|
| and when you say you've tried to restore back to a point in time i presume you are taking transaction log backups |
|
|
|
|
|
|
Records Missing