Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-06-08 : 07:40:53
|
| Hi experts,Is there any way to restore the table structure or stored procedures alone from a database backup ?Thanks & Regards,HariArul |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-08 : 07:42:12
|
| no.restore the backup with a different db name and get it from there._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-06-08 : 07:47:18
|
| Thanks Spirit. My problem is , this is a very huge database ( 90 GB's ) and would be difficult to do a complete resotore. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-08 : 10:24:34
|
| Can you just "Script" all the objects from the original database?And then run that script on a brand new, empty, database?Kristen |
|
|
|
|
|
|
Restore objects alone.