Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    9

    Question Unanswered: Point-In-Time Restoration Issue

    Hello,

    I'm testing "Point In Time" restoration for my system using both Database & Log backup files. (Database backup once a day; Log backup every 4 hours)

    When I use T-SQL to perfrom the restoration, I can specify one .BAK file with numerous .TRN files and restore to any 'point of time' with no issue.

    However, if I use EM to perform the same restoration, I can only specify one .BAK file with a maximum of two .TRN files (although I can see all the .TRN files) in order to restore the database properly. If I specify more .TRN files, after restoration, my DB will be in 'LOADING' status and can't be used.

    Does anyone encounter the same problem before and know what is going on?

    Thank You.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    When restoring a database with Enterprise Manager, make sure the 'Leave Database Operational' is checked.

  3. #3
    Join Date
    May 2004
    Posts
    7
    you can also always switch the database from "Loading" to "operational" modes with simple tsql command

    restore database <Dbname> with recovery

    simas

  4. #4
    Join Date
    Mar 2004
    Posts
    9
    hi guys,

    thanks for the replies. I'll look into it.

    btw, I did found out some documentation that closely describe my problem, it's "Microsoft Knowledge Base Article - 319697, FIX: SQL Enterprise Manager Restore to Point in Time Does Not Stop at Requested Time and the Database is Left in a Loading State"

    Seems like it's not something new...

    Thank You.

Posting Permissions

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