Restore a table from db.

[kmsam2]

any idea how to restore a table from a database in MS SQL 2000? My database is too huge (1.5TB), I just need 1 of the table only.

Sam.

 

[mutley1]

Not as far as I am aware - you'll have to restore it somewhere then copy the table over.

HTH,

M.

 

[piti]

try this

http://www.quest.com/litespeed-for-sql-server/

 

[ptheriault]

In order to restore with litespeed you would have had to backed the db up with litespeed. mutley is correct. The only way is to restore the database to another server and restore the table you need. However, I should caution you on doing just one table. You could cause data integrity problems if there are FK relationships with other tables.
If you have the transaction log from a time frame when the table was good. you may be able to use a tool like lumigent log explorer to undo the bad transaction.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[onpnt]

You can also possibly look at your backup and recovery plan a bit closer to prevent these things. If you have tables that are business critical (not that the entire DB isn't) you can set up file groups for high transactional tables.

This probably should have been done in the first place on a DB that size for performance reasons alone.

If anything I hope you take this event and better the planning for these in the future

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[onpnt]

Read up here

http://msdn2.microsoft.com/en-us/library/ms191455(SQL.90).aspx

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}