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)
 resoring backup

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-03-29 : 10:04:34
Hi,


we have backup strategy is like this
every sunday 2.am full backup
monday to saturday 11.30 pm differential backup
every one hour transactional backup between 8.00am to 10.30 pm
on thursday at 7.30 server was failure
the last transacational backup is taken at 7.00pm
but i don't want to lose any transactiona after 7.00pm

how can i restore database before point of failure

please suggest me


please suggest me
   

- Advertisement -