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»»

Database restore commands Expand / Collapse
Author
Message
Posted Wednesday, March 17, 2010 9:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 8:46 PM
Points: 2,333, Visits: 3,896
Comments posted to this topic are about the item Database restore commands

M&M
Post #885188
Posted Wednesday, March 17, 2010 9:15 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
Thank you.

This is a good refresher and important topic.

Good question




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #885189
Posted Wednesday, March 17, 2010 10:35 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 1, 2016 1:19 AM
Points: 2,004, Visits: 3,187
Basic question on restore. Helpfull to beginners especialy.
Post #885216
Posted Wednesday, March 17, 2010 10:36 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2016 5:42 AM
Points: 2,825, Visits: 374
thanks

glad to get 2 points... however had to read the msdn to get the correct answer!
Post #885217
Posted Wednesday, March 17, 2010 10:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 10:46 PM
Points: 1, Visits: 0
Yaaaaa,i am agree.nice

Livea
Post #885227
Posted Thursday, March 18, 2010 12:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 26, 2016 1:29 PM
Points: 2,523, Visits: 1,642
Normally there are 3 types while performing restoration,

1.Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH ----)

2.Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH ----)

3.Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH ----)
Post #885279
Posted Thursday, March 18, 2010 5:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 30, 2016 8:36 AM
Points: 590, Visits: 1,658
Easy 2 points today! Good question though and a topic that every DBA should be familiar with.
Post #885376
Posted Thursday, March 18, 2010 5:51 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
Thanks for the 2 points!

Only 54% correct so far, there's too many devs on this site! So its good they learnt something important



---------------------------------------------------------------------

Post #885402
Posted Thursday, March 18, 2010 6:44 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, March 3, 2015 4:07 PM
Points: 493, Visits: 639
2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log restore, but you might also want to restore with norecovery on the full backup because you want to apply a differential restore.
Post #885440
Posted Thursday, March 18, 2010 9:15 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
george sibbald (3/18/2010)
Thanks for the 2 points!

Only 54% correct so far, there's too many devs on this site! So its good they learnt something important




LOL
Thanks George




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #885612
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse