Networker

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

2012-06-22 13:02:47
Subject: [Networker] Fw: [Networker] MSSQL recover with "norecover" option - not returning the right database ... SOLVED
From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 22 Jun 2012 12:50:35 -0400
> So I think we finally figured it out. By default, the option "
> "transaction log backup before rstoring Ms sql 2005 and newer db" 
> had been checked. Apparently, this option MUST be UNCHECKED, in 
> order for a "No Recovery" restore to properly occur. Why? I have no 
> idea. :-) But if you leave it checked (figuring, as I did, and as 
> Tech Support agreed with me last night), that it would have no 
> effect, as you are doing a restore not a backup ... then the file 
> you get back is not the file you wanted. Or that I needed, anyway.
> 
> Anyways, unchecking that started a restore of the db file from the 
> proper date, and with the proper size. It'll take hours and hours 
> yet to finish, but it all Looks Good, for the moment.

<Prev in Thread] Current Thread [Next in Thread>
  • [Networker] Fw: [Networker] MSSQL recover with "norecover" option - not returning the right database ... SOLVED, Michael Leone <=