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.
| Author |
Topic |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
 Posted - 2011-02-15 : 02:45:23
|
| hii use to take Full backup on ad-hoc basis of a specific database. I did it on 01 Jan 2011, 16 Jan 2011 and 09 Feb 2011. My requirements are to re-instate the 19 Jan 2011 1:00 AM state. Now when I try to restore the backup of 09 Feb 2011 From Disk, and specify the "Point in Time"=19 Jan 2011 1:00 AM option via SSMS GUI (using SQL server 2008), the details of the selected .bak file gets disappeared from the details window (just below the From Device box)confused as if isn't it possible to have point in time recovery using the .Bak file? Or what else could be the reason .. Many thanks! MIK |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-15 : 03:55:39
|
| A full backup can only restore to the point that the backup was taken. The StopAt command is allowed when restoring full backups, but it is ignored completely.--Gail ShawSQL Server MVP |
 |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-15 : 04:55:26
|
| many thanks to both .. CheersMIK |
|
|
|
|
|
|
Restore to a point in time