> Here's a weird one. My DBAs need a MS SQL DB restored, and they need it
> done as a "No Recover" sort of restore. That's (apparently) a special
kind
> of MS SQL restore, which would allow them to replay the transaction
logs,
> and bring the DB back to the point in time they want.
>
> So I go to the client (a SQL 2008 cluster, so it's a virtual client),
fire
> up the SQL Module GUI, choose a recover (copy), and browse back to the
> date I want (2012-06-19), choose my DB, see that it has the right size
for
> that date (567G - it's a big one), and change the properties to choose a
> "No Recover" restore, and change the destination path so it goes to a
new
> folder. All well and good, and just like the manual says.
>
> But what I get back is the database as of 2012-06-20 (i.e, the next
day).
> When my guys open the restored DB, they say it reports that it was
backed
> up 2012-06-19, and at the time of the backup of 2012-06-20.
Grrr ... that's supposed to say "they say it reports that it was backed
up 2012-06-20, and at the time of the backup of 2012-06-20"
|