SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Data disappeared (Users missing)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/03/2006 :  20:23:00  Show Profile  Reply with Quote
hello,
am not sure if this is the right forum to post this.

We have a couple of sites running MS SQL, however we have never had issues with data corruption.

I was working with a certain site and then noticed that all users in the users table were missing except one.

Secondly, the users table had all permissions revoked.

how did this happen and whats the best way to go about restoring it.

Ehi

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 09/03/2006 :  20:54:32  Show Profile  Reply with Quote
somebody made some changes, becuase the data won't just disappear - unless the table is corrupted. a DBCC CHECKDB will tell you if you have any corruption.

The way to get it back is to restore your database to another location, and then check the table. If the data is there, copy it across. If it isn't, you go to an earlier backup and repeat.

please tell me you have backups.



-ec
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/04/2006 :  18:34:27  Show Profile  Reply with Quote
thanks Eyechart,
sure we do have backups and doing a restore now.

We have never had issues with data corruption in my 4 years working with MS SQL. However, We learn everyday.

Afrika
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 09/05/2006 :  06:53:13  Show Profile  Reply with Quote
Its a bitch, for sure.

Last database corruption we had was when a RAID drive went down - which really pissed me off because the whole reason we had RAID was to be immune from hardware failures!!

Kristen
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 09/05/2006 :  17:30:58  Show Profile  Visit paulrandal's Homepage  Reply with Quote
quote:
Originally posted by afrika

thanks Eyechart,
sure we do have backups and doing a restore now.

We have never had issues with data corruption in my 4 years working with MS SQL. However, We learn everyday.

Afrika



How do you know this is data corruption? Sounds more like someone changed the data (accidentally or deliberately). Does CHECKDB come back clean?

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/05/2006 :  18:24:34  Show Profile  Reply with Quote
quote:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'afrika'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.



everything is ok.

Anyway,

... we did a restore, and ...
...we are migrating hosts. So i guess that would be my next set of questions.

afrika
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000