Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    New Jersey
    Posts
    65

    Unanswered: Restored a DB With NORECOVERY - Bring Back On-line?

    In our test environment, we have a DB that was (edit: accidentally) restored with NORECOVERY. Besides just re-restoring the DB, what is the T-SQL command to bring the database back on-line?
    Last edited by HardCode; 06-09-10 at 12:35.
    Retired Moderator at Xtreme VB Talk, for all of your Visual Basic needs.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    RESTORE DATABASE database_name WITH RECOVERY
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ordinarily you would simply include the WITH RECOVERY option on restore. If you are ready to recover I believe it is:
    Code:
    RESTORE DATABASE myDB WITH RECOVERY
    i.e. no backup specified.

  4. #4
    Join Date
    Oct 2004
    Location
    New Jersey
    Posts
    65
    Excellent. Thanks!
    Retired Moderator at Xtreme VB Talk, for all of your Visual Basic needs.

Posting Permissions

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