Restore Schema from full backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Restore Schema from full backup

  1. #1
    Join Date
    Aug 2008
    Posts
    118

    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

  2. #2
    Join Date
    Aug 2008
    Posts
    118
    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

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool 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

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool Restore/Recover/Export/Import

    Quote Originally Posted by midora View Post
    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
  •  



Click Here to Expand Forum to Full Width