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

Understanding restore and recovery in sql Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 3:25 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
I want to know exact mechanism used while restoring a database.Not getting the three phases of restoring i.e
copy,undo and redo.
what do u mean by roll forward set?
Post #1337125
Posted Tuesday, July 31, 2012 12:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:09 PM
Points: 431, Visits: 575
Have you tried these articles?
Restore and Recovery of Backups
http://msdn.microsoft.com/en-us/library/ms191455(v=SQL.105).aspx
Controlling Creation of Added Files During Roll Forward
http://msdn.microsoft.com/en-us/library/ms190208(v=sql.105).aspx
Post #1338079
Posted Tuesday, July 31, 2012 12:17 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:12 PM
Points: 22,492, Visits: 30,191
ahperez (7/31/2012)
Have you tried these articles?
Restore and Recovery of Backups
http://msdn.microsoft.com/en-us/library/ms191455(v=SQL.105).aspx
Controlling Creation of Added Files During Roll Forward
http://msdn.microsoft.com/en-us/library/ms190208(v=sql.105).aspx


Makingit easier for others:

Restore and Recovery of Backups
http://msdn.microsoft.com/en-us/library/ms191455(v=SQL.105).aspx
Controlling Creation of Added Files During Roll Forward
http://msdn.microsoft.com/en-us/library/ms190208(v=sql.105).aspx



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1338088
Posted Saturday, August 04, 2012 12:42 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
Thanks for information u sent.
Post #1340166
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse