Corruption in a single record - SQL Server Forums

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.

All Forums

General SQL Server Forums

Data Corruption Issues

Corruption in a single record

Author

Topic

smilysanjai
Starting Member

1 Post

Posted - 2010-09-09 : 04:13:53

Is there any chance of corruptions in a single record with in a table from SQL 2005 ?

If so, can anybody share with me what are the Causes of corruption and the consequences?

What will the solution also?

Sanjai Prasad.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-09 : 04:30:38

Yes

IO subsystem. Unreadable and lost data, high severity error messages

Restore from clean backup

--
Gail Shaw
SQL Server MVP

Offshoreally
Starting Member

1 Post

Posted - 2010-09-14 : 01:57:35

I'm a newbie here. I stumbled upon this discussion and found it very informative and useful for me. Thanks for sharing this important info.:-)

spam removed

sks198117
Starting Member

46 Posts

Posted - 2010-09-17 : 10:50:44

There might be a chance that a single data page is corrupt due some IO/disk error and you can restore a single data page from a valid backup file.
Check the RESTORE DATABASE on BOL for detail RESTORE TSQL.

Thanks

---Thanks---
Santosh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources