point in time recovery or restore

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  May 12, 2006 at 12:05 pm

  #114642

  I am testing point in time recovery. Here is my scenario.

  Created a database called test. inserted some database and took a full backup.

  After the full backup inserted some more data and backed up transaction log.

  now I am trying to restore the database to a point in time using following statements

   

  RESTORE DATABASE test

  FROM DISK = '\\006-pm2-dbasql\TransactionLogs\test'

  WITH REPLACE, NORECOVERY

  This keeps uncommitted transactions open and the database in an intermediate, non-recovered state, ready for the logs to be applied. On that note, let’s get started:

  RESTORE LOG test

  FROM DISK = '\\006-pm2-dbasql\TransactionLogs\testtranslog1056'

  WITH RECOVERY, STOPAT = 'May 17, 2006 10:56 AM',

  FILE = 1

   

  Commands run successfully. However when I look in enterprise manager database is marked 'loading'. can someone explain why is that happening?

  also file=1, what is this referring to?

   

  thanks

   

• Tom Goltl

  SSCertifiable

  Points: 5815

  More actions

  May 12, 2006 at 12:30 pm

  #637666

  If I remember right, you have to Issue the

  restore database test with recovery

  after you restore the log.

  Tom

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  May 12, 2006 at 12:34 pm

  #637668

  that worked. interestingly i didnt see this command in the article I used to do point in time recovery.

  is there good source with scenarios that I can refer to?

  thanks