Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Unanswered: Recover Dropped Db ?

    Is there a way to recover a dropped db (with reloading) ?

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Yes you can recreate the database and load from the last dump

    Or if you have a resent printout of sysusages and sysdatabases then you can re-insert the values for the dropped database and run dbcc checkdb to fix the free space info and restart sybase server.

    Or if you have a resent backup of master that contain the required sysdatabases and sysusages info then load master from that dump.

    NB. Make backups before you start to fiddle so that you can at least get back to this point in time. Shutdown your sybase server and make copies of the master and dropped db device files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts