May 12, 2006 at 12:27 pm
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
May 13, 2006 at 9:04 am
Hi,
Did you refresh the enterprise manager gui.
Check. If restore is successfull then there should not be issues with the database . just refresh.
May 15, 2006 at 3:04 pm
File = 1 indicates that you want to restore the first backup set in the backup file. This is used if you store multiple backup sets in the same file. It could be omitted from the RESTORE command if there is only one backup in the file.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply