January 8, 2008 at 3:38 pm
could any one tell me what am I doing wrong here:
I have 2 transaction log backups which was taken 9AM and 2PM today. whenever I execute the 2PM restore getting the following error :
Processed 2672 pages for database 'JB', file 'JB_Data' on file 1.
Processed 1 pages for database 'JB', file 'JB_Log' on file 1.
RESTORE DATABASE successfully processed 2673 pages in 9.599 seconds (2.280 MB/sec).
Processed 1 pages for database 'JB', file 'JB_Log' on file 1.
This log file contains records logged before the designated point-in-time. The database is being left in load state so you can apply another log file.
RESTORE LOG successfully processed 1 pages in 0.111 seconds (0.073 MB/sec).
Following are the Log backup and Restore Script:
BACKUP LOG JB TO JBlog_1
RESTORE DATABASE JB
FROM JBdata_1
WITH NORECOVERY
RESTORE LOG JB
FROM JBlog_1
WITH RECOVERY, STOPAT = 'Jan 08, 2008 2:00 PM'
Thanks in Advance
January 8, 2008 at 4:00 pm
First, are you applying both transaction log backups after you restore the full backup? Second, if you are restoring to the point in time of the second transaction log backup, leave off the stopat. You are basiclly restoring to the most current time based on the backups available.
😎
January 8, 2008 at 4:32 pm
Thank You. It works.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply