Restoring a single SQL 2005 Table

Question

Hello, I am trying to figure out if there is a way to restore a single table from a SQL Server 2005 Database. As of right now, I can restore the whole database, but many times this is too much and I would like to restore just a single file (table). I read through the Networker Module for SQL 5.1 documentation and didn't see any information in there regarding this level of restore. If anyone could provide some guidance on this issue, I would greatly appreciate it. Thank you for all of your help!

ble1 · Answer

I believe the closest you can get is partial restore (piecemeal) if you have enterprise edition.

SigmaAdmin · Answer

Thank you for your response. I did try the piecement restore, but it doesn't look like there are any options to restore anything other than the whole database....Any other ideas?

ble1 · Answer

Do you have Enterprise Edition of SQL?

NetWorker

Was this post helpful?