February 9, 2009 at 2:32 am
Suppose I am taking daily nigt taking full backup,,every 2 hours taking differnetial backup.every 1 hour taking transcation log backup.
I have transcation log backup ...01:00PM..but my database is crashed on 01:15PM.How to retrive the 15 Mins Data.
February 9, 2009 at 4:41 am
You can use stopat clause..
you can see syntax and details in help
type restore database and press cntrl+shift+f2
you can see details over there.
February 9, 2009 at 10:48 am
Depends on the type of crash. If the tran log is still available and SQL is still running, then you can take a tail-log backup (see books online for details, the option is NO_Truncate under BACKUP LOG)
If the log file is not available, then you cannot retrieve that 15 min of data. That's why the interval between tran log backups should be the maximum data that you are willing to lose in a disaster.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply