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 - 2002-07-10 : 08:52:21
|
| Eugen writes "Good afternoon, My name is Eugen Tirulnic and I am a DBA in a clinic. We run a small business operation system on a server with processor Athlon 1GHz , 512 MB RAM, HD controller RAID IDE in a mirror mode 2HD, 20 GB, Windows 2000, SQL Server 2000. My problem is that a couple of days ago when I or any user tried to access some of the tables i've got an error with message like "Error on access to file c:\....\...\data\ppp.mdf at offset ......" I set up my SQL Server to make a complete backup of DB every day at 5PM. When I have tried to restore the data I read "Error on the address...in the file...". I do back up at 5 pm every day. I managed to restore the data until the 23rd of June. I restored 99% but still I have the "turn on page" error. Now I expect to be able to complete the restoration. But I miss something and I don't know what. I mention that I did no relevant training in SQL and I use only my personal knowledge and experience. Anyway, I am in big trouble and that is why I'm calling out for help. I am grateful for any input. thank youEugen" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-10 : 10:10:21
|
| I would recommend running CHKDSK or ScanDisk, or if your RAID controller came with a special disk fix utility, use that instead. It's possible the hard disk has some bad sectors and may have corrupted the file. I would recommend against trying to restore the data until you check the disk(s) out first. |
 |
|
|
|
|
|
Restore partial DB