DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Restore Schema from full backup

  1. 04-28-2009, 01:45 PM #1
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123

    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
    Reply With Quote Reply With Quote
  2. 04-28-2009, 01:58 PM #2
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123
    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
    Reply With Quote Reply With Quote
  3. 04-28-2009, 01:58 PM #3
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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
    Reply With Quote Reply With Quote
  4. 04-28-2009, 02:04 PM #4
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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