Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server

Hello Everybody, I think you will all agree with me that database corruption is one of the nightmares in the life of a DBA. We store precious data in databases and each day the dataset grows bigger and bigger. A database corruption issue not only puts the data at risk, it also threatens to take…

13

Property Owner is not available for Database ‘[DBName]’.

Hi Friends, This issue that I am talking about is a very common issue that I have seen. I have, in my experience, seen many users experiencing this issue; yet, most people do not know how to troubleshoot or fix this issue. Moreover, I have seen this issue on SQL Server 2005; although not tested,…

27

Invalid object name ‘master.dbo.spt_values’. (Microsoft SQL Server, Error: 208)

Hi Friends, The last month has been a very busy month for all of us, and its not over yet. However, with the daily work, comes a few instances when we do encounter really interesting issues. End of the last month, I encountered an issue, that is really very interesting. The issue that I am…

30