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

    Unanswered: How do it restore from a dump?

    I have a good dump of my database. It ended up getting corrupted.
    I have a good dump from a few days ago and I would like to know how
    to restore or load from that dump.
    The corrupt database was marked as suspect
    and I found online how to get could finally drop it because I could not load to it.
    Can anyone provide the process or correct syntax?

    This is our backup server and we hope to migrate it because the primary is the corrupting database. Anything you provide will be helpful.

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1

    Syntax to drop a suspect database

    dbcc dbrepair (database_name, dropdb)

Posting Permissions

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