How do I restore a single table in SQL SERVER 2005?

If I have just one corrupt table in a database and I only want to restore one table is this possible either through a script or a function in SQL SERVER MGMT STUDIO?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

No can do....Need to restore the db to another db w/ a different name and move the table over.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree.

unless that table was the only one in it's dedicated filegroup ...
but that's unlikely here, otherwise you would know how to restore that also.
>>unless that table was the only one in it's dedicated filegroup ...

I almost wrote that, but then the reasoning from your last sentence kicked in for me.  :)
it depends. SQL Server 2005 introduced ability to restore a specific "page" from SQL Server 2005 backup, and it would be fun to write a script to restore a table by restoring piece meal pages out of backup.

Chances are you do not need to restore the table, if all you need is to make sure that table corruption goes away. In addition there is always dbcc checktable, technet link:

In addition if by chance you are using backup tools, such as SQL LiteSpeed from Quest it has built - in ability to restore specific table.
We use SQL LiteSpeed from Quest for that reason.  Also, because of good compression ability.

One last option is to restore the entire database to a different server or as a different dbname on the same server and copy the table from the resored database to your production database.
This option will work if you have disk space available.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.