Results 1 to 10 of 10

Thread: stop restore

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: stop restore

    Hi all I have a question, how do you make a database stop the restore process??

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you are restoring a transaction log ot a point in time, there is the STOPAT parameter. Is that what you are after?

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    yes how do I do that??

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Ok here is whats going on Transaction logs are being backed up. in the options area says Under Transaction Log
    BACK UP THE TAIL OF THE LOG, AND LEAVE THE DATABASE IN THE RESTORING STATE.

  5. #5
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    And your question is?????? The restore PIT is pretty straightforward. I'm not 100% sure what your issue is....

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    the database is in restore mode how do I make it stop??

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Code:
    Restore database [databasename] with recovery

  8. #8
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by MCrowley
    Code:
    Restore database [databasename] with recovery

    Thank you so much, darn I am trying to do a backup of the Tail logs and it took a long time. It was stuck in the restore mode for 45mins and I was starting to get worried

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How big was your dump?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    it was 174,655KB

Posting Permissions

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