Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Restore of the Database Expand / Collapse
Author
Message
Posted Wednesday, January 21, 2009 7:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:20 AM
Points: 34,087, Visits: 18,224
Why is verify history needed? I've never used this on the same server since backups are usually known quantities. It's on a DR server I might check since I don't have backup history.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #640703
Posted Wednesday, January 21, 2009 7:48 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648

The question probably should have said that RESTORE VERIFYONLY doesn't write to the msdb.dbo.restorehistory by default. But there is the LOADHISTORY parameter that will make it so.
Post #640730
Posted Wednesday, January 21, 2009 1:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 22, 2010 10:53 AM
Points: 143, Visits: 13
I agree with Warren. In MSDN its clearly written that msdb.restorehistory contains one row for each restore operation.
For VERIFYONLY restore option column [restore_type] will contain 'V'
V = Verifyonly
Post #641103
Posted Wednesday, January 21, 2009 3:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 4, 2015 2:43 AM
Points: 2,953, Visits: 440
igorg (1/21/2009)
I agree with Warren. In MSDN its clearly written that msdb.restorehistory contains one row for each restore operation.
For VERIFYONLY restore option column [restore_type] will contain 'V'
V = Verifyonly


RESTORE VERIFYONLY can write to history system table if you specify LOADHISTORY option. The question doesn't mention this at all, so the answer is No.



Urbis, an urban transformation company
Post #641204
Posted Tuesday, June 23, 2009 8:26 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:28 PM
Points: 9,633, Visits: 11,662
Iggy (1/21/2009)
igorg (1/21/2009)
I agree with Warren. In MSDN its clearly written that msdb.restorehistory contains one row for each restore operation.
For VERIFYONLY restore option column [restore_type] will contain 'V'
V = Verifyonly


RESTORE VERIFYONLY can write to history system table if you specify LOADHISTORY option. The question doesn't mention this at all, so the answer is No.


No. it's a stupid question and the correct answer "Only if LOADHISTORY" is specified isn't available.


Tom
Post #740224
Posted Monday, May 9, 2016 7:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 11, 2016 10:02 AM
Points: 2,434, Visits: 201
Hi,

Please check the correct answer!!!

The official Microsoft documentation informs the operation of verifyonly is written in the table.


To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx
Post #1784377
Posted Monday, May 9, 2016 8:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 4, 2016 6:59 AM
Points: 2,126, Visits: 6,468
Junior Galvão - MVP (5/9/2016)
Hi,

Please check the correct answer!!!

The official Microsoft documentation informs the operation of verifyonly is written in the table.


To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx


Uhmmm... This question is 6 years old


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1784412
Posted Tuesday, May 10, 2016 3:54 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:28 PM
Points: 9,633, Visits: 11,662
Jan Van der Eecken (5/9/2016)
Junior Galvão - MVP (5/9/2016)
Hi,

Please check the correct answer!!!

The official Microsoft documentation informs the operation of verifyonly is written in the table.


To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx


Uhmmm... This question is 6 years old

So it's been standing there wrong - uncorrected - for 7 (not 6) years despite the error having been pointed out 7 years ago. How many people have looked at it and been misled during those 7 years? Do we want SQLServerCentral to carry on misleading people for ever, or should people who spot the uncorrected error comment on it in the hope that it may be fixed even at this late date so that it won't mislead people in the future? If that's a forlorn hope, what does that say about the site? And if you think people shouldn't comment, what does that say about you?


Tom
Post #1784978
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse