-
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
-
Clone
Restore database as "clone" either to same server or another host.
Then export/import schema(s).
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Restore/Recover/Export/Import
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.
Last edited by LKBrwn_DBA; 04-28-2009 at 02:06 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|