Showing posts with label objects. Show all posts
Showing posts with label objects. Show all posts

Wednesday, March 7, 2012

Restore objects from backup.

Hi experts,

Is there any way to restore the table structure or stored procedures alone from a database backup ?

Thanks & Regards,

DBLearner

There are no direct ways to that. Anyway, you could restore database with another name on the server and copy whatever you want from it.
|||When restoring a SQL Server backup you have to restore all the data. After restoring you can trucnate the tables which will give you the schema and procedures only.|||

No there is no way to restore a table structure from a database backup without restoring the entire database.

regarDs,

Jacx