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

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 5:52 PM
Points: 2,270, Visits: 3,789
Comments posted to this topic are about the item Database restore commands

Mohammed Moinudheen
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: Yesterday @ 1:51 PM
Points: 21,644, Visits: 15,317
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #885189
Posted Wednesday, March 17, 2010 10:35 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
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: Monday, June 30, 2014 2:51 AM
Points: 2,008, Visits: 369
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: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
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: Tuesday, August 26, 2014 3:55 AM
Points: 558, Visits: 1,475
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: Yesterday @ 3:40 AM
Points: 5,989, Visits: 12,925
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: Friday, November 9, 2012 2:48 PM
Points: 493, Visits: 636
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: Yesterday @ 1:51 PM
Points: 21,644, Visits: 15,317
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #885612
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse