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 Thursday, March 18, 2010 11:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
Toby White (3/18/2010)
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.


Thanks, I agree. Even I got confused when I read the question today

I will try next time, to present more clearly.


Mohammed Moinudheen
Post #885766
Posted Thursday, March 18, 2010 3:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:48 AM
Points: 2,015, Visits: 2,843
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



You wouldn't have anything to do without us "devs".
Post #885945
Posted Tuesday, March 30, 2010 8:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989, Visits: 10,532
Define 'developer'...



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892791
Posted Tuesday, March 30, 2010 8:17 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:02 PM
Points: 5,269, Visits: 11,203
Paul White NZ (3/30/2010)
Define 'developer'...


people what code but can't restore databases!


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

Post #892813
Posted Tuesday, March 30, 2010 11:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989, Visits: 10,532
george sibbald (3/30/2010)
Paul White NZ (3/30/2010)
Define 'developer'...

people what code but can't restore databases!

I called myself a Database Developer for many years...




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893077
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse