Networker

Re: [Networker] MSSQL recover with "norecover" option - not returning the right database ...

2012-06-22 07:58:51
Subject: Re: [Networker] MSSQL recover with "norecover" option - not returning the right database ...
From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 22 Jun 2012 07:48:21 -0400
> 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"

<Prev in Thread] Current Thread [Next in Thread>