Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Today @ 3:06 PM
Points: 33,169, Visits: 15,304
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: 2 days ago @ 11:27 PM
Points: 3,901, Visits: 3,634

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: Sunday, August 3, 2014 10:04 PM
Points: 2,953, Visits: 437
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: Today @ 4:54 PM
Points: 8,689, Visits: 9,223
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
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse