need help with SQL server

[gabrielcox]

Hi all.

I can`t run my SQL Server.

I see “SQL Server Table Corruption Error”  It used to work just fine not long ago.

Is there a way to solve my problem? I tied to recover it with advices from the web like using the Microsoft SQL server restore feature but that`s not helping.

 

[TidaLWaveZ]

Can you post the full error and explain what triggers the error message?

[madknight3]

There can be many reasons for a corruption failure. I've never dealt with this before so I can't be of much help. My first instinct would be to try an SQL Server repair tool as the link suggests. You can google "SQL Server repair tool" or something like that to find a bunch of options.

 

In the future, keep backups.

[liamharper]

Hi there, devil in details. So those details would be good to know.

Before you done anything else make a backup! Like madknight3 says.  It`s just common sence. In case something goes wrong.

See this microsoft

database repair tips

You can use the restore feature of Microsoft SQL Server. To do this, follow these steps:

1.Click Start, click AllPrograms, click Microsoft SQL Server, and then click SQL Server Management Studio.
2.In the Connect to Server dialog, the Server Type should be "Database Engine". Check the Server name and Authentication and make changes if needed, then click the Connect button.
3.Expand SQL Server if needed and then expand Databases.
4.Right-click the database, point to All Tasks, and then click Restore then click Database….
5.From the list of backups, click the backup to restore, and then click OK to start the restore.

6.Click OK to confirm that the restore completed successfully.

You might also find usefull a 3rd party restoration program  SQL Server Repair Toolbox to recover data from corrupt mdf file. Most of the software have demo version that shows the preview of corrupt SQL server data file. And you can see if it is going to help you or not.
I hope from the list above at least one thing should help.

Good luck.