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

Thread: Restore Schema from full backup

Threaded View

  1. 04-28-2009, 02:04 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 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