Error While Accessing the Recordrs for SQL Server Database

[expired user #9139]'s profile image [expired user #9139] posted 9 years ago in Running SQL scripts Permalink
I am getting an error while accessing the records from the SQL database:

"Unable to process index I_NAME of table O_NAME because filegroup F_NAME is invalid"

please help me!
[expired user #9138]'s profile image [expired user #9138] posted 9 years ago Permalink
Reason of the above problem is one of the file group IDs saved in Meta data for indexes do not exist and the index cannot be checked.Check your hardware,Run the diagnostic and correct the problem if any.
[expired user #9139]'s profile image [expired user #9139] posted 9 years ago Permalink
I have checked the hardware but it is working very well. Now what to do?
[expired user #9138]'s profile image [expired user #9138] posted 9 years ago Permalink
Hi David,

If you have the clean and updated backup then you can restore your database from it.If you do not have any clean backup then, run DBCC CHECKDB command without repair clause to check the extent of corruption. Again run the same command with the proper repair option to isolate the problem.

Good Luck!
[expired user #9139]'s profile image [expired user #9139] posted 9 years ago Permalink
I do not have backup so I tried the second option. It's not working.unhappy

Please suggest me any tool free or paid so because my data is very important.
[expired user #9138]'s profile image [expired user #9138] posted 9 years ago Permalink
I do not have much idea about free tools but I can suggest on paid tool to repair your important data.you can try stellar sql database repair tool.here is the link:
http://www.stellarinfo.com/sql-recovery.htm

Note: Please try the demo version of any data recovery tool before complete registration.​
[expired user #9139]'s profile image [expired user #9139] posted 9 years ago Permalink
Yipeee it worked...

Many many thanks to you laura and you made my day. :)
TTSneko's profile image TTSneko posted 8 years ago Permalink

I love how people suddenly panic when they lose "oh so important data" but at the same time admit that they do not have a backup ...

Please login to leave a reply, or register at first.