Restore Schema from full backup

Hi all,

Please guide me how to restore Schema from Full backup please.

I have last weekend full backup and need to restore specific Schema.

Thanks
Pat

Also,

someone lost the schema and need to restore. Last night.

is it possible to get if rom redo log and get what it was before change?

Thanks

Restore database as "clone" either to same server or another host.
Then export/import schema(s).
;)

Quote:

---

Originally Posted by midora

Also,
someone lost the schema and need to restore. Last night.
is it possible to get if rom redo log and get what it was before change?
Thanks

---

Using Weekend full backup:

1) You could restore primary database to before change from backup and apply archive logs, but then you would loose everything that occured after change (not only for that schema).

2) Or restore your backup as suggested in above post, recover until before change, then export/import.
:p