point in time restore - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

point in time restore

Author

Topic

sreenivasa.rao
Starting Member

3 Posts

Posted - 2006-12-01 : 03:07:28

Hi,
We have a fullback on sunday at 1 am
diffrential back up every day at 7pm
transaction log backup every 1 hr

on thursday 10:14 am server crashes?

can u pls sugg me how to restore up to point of time(10:14 am) failure thru qa?

Thanks & regards
sreenivas

Kristen
Test

22859 Posts

Posted - 2006-12-01 : 03:26:45

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example,Restore

Kristen

monty
Posting Yak Master

130 Posts

Posted - 2006-12-03 : 06:44:19

Hi,

first restore the full backup of sunday....

1)RESTORE DATABASE db_name
FROM backup_device
WITH NORECOVERY

next apply the diffrential restore of Wednesdays

2)RESTORE DATABASE db_name
FROM backup_device
WITH NORECOVERY

next apply all the logs from 8pm Wednesday to the latest one 10:14 Am thursday..

3)RESTORE LOG db_name
FROM db_name_log1
WITH NORECOVERY

apply the last log as

4)RESTORE LOG db_name
FROM db_name_logn
WITH RECOVERY, STOPAT = 'NOV 29, 2006 10:14 AM'

NOTE:if the time specified is beyond the end of the time covered by the transaction log), a warning is generated and the database remains unrecovered.

its me monty

Kristen
Test

22859 Posts

Posted - 2006-12-03 : 08:22:51

In this case you would need to take one final TLog backup before you started your restore.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources