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

Point-in-time restore Expand / Collapse
Author
Message
Posted Tuesday, February 15, 2011 10:17 PM
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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
Comments posted to this topic are about the item Point-in-time restore
Post #1064713
Posted Tuesday, February 15, 2011 10:20 PM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 6:49 AM
Points: 1,443, Visits: 1,855
Good one! I had to refer BOL for this one because we don't use Bulk-logged mode, but it was fun learning something new today. Thank-you!

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1064715
Posted Tuesday, February 15, 2011 10:37 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
I messed up. Very good question.

Mohammed Moinudheen
Post #1064717
Posted Wednesday, February 16, 2011 12:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
Great question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1064744
Posted Wednesday, February 16, 2011 1:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:11 AM
Points: 1,287, Visits: 2,261
Nakul Vachhrajani (2/15/2011)
I had to refer BOL for this one because we don't use Bulk-logged mode.

Sadly, my BOL diving didn't go deep enough. I got to here: http://msdn.microsoft.com/en-us/library/ms189275(SQL.100).aspx, which states twice that it's not supported - you have to go a bit further to find where it says that it is.
Post #1064767
Posted Wednesday, February 16, 2011 3:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Having not used Bulk options, I managed to do enough digging to find out it was a conditional yes, just chose the wrong one. Thought you would be okay as long as there was no bulk operations since last full backup.

I guess not


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1064800
Posted Wednesday, February 16, 2011 3:46 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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
DugyC (2/16/2011)
Having not used Bulk options, I managed to do enough digging to find out it was a conditional yes, just chose the wrong one. Thought you would be okay as long as there was no bulk operations since last full backup.

I guess not


You would indeed be ok, but the answer said "Yes, but only if.." which I intended to mean that if there had been no bulk operations since the last full backup you would be ok, but otherwise not.

I was thinking of a situation where you might have multiple log backups since the last full backup, several of which might contain bulk operations. As long as the log backup you want to restore to a point in time with doesn't have any, you can restore to that particular point in time. Of course, if none of them have any bulk operations in them you can use any of them to restore to a point in time.

I apologise for any confusion caused - but as you can imagine, wording something to be completely unambiguous is not as easy as it seems!

Thanks for the feedback

Duncan
Post #1064807
Posted Wednesday, February 16, 2011 7:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:10 AM
Points: 1,370, Visits: 506
It's a good question, but maybe next time you should take a notice: using Server 2005 and above.
Post #1064965
Posted Wednesday, February 16, 2011 7:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 11:26 AM
Points: 668, Visits: 485
Nice question!! I had to search for the correct answer.
Post #1065005
Posted Wednesday, February 16, 2011 7:58 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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
palotaiarpad (2/16/2011)
It's a good question, but maybe next time you should take a notice: using Server 2005 and above.


The question is valid equally for SQL Server 2000/2005/2008. I'm not sure if the exact STOPAT syntax was available in SQL Server 7 (point-in-time recovery was, so I assume yes?), but in any case there was no BULK_LOGGED recovery model as such. Instead there was the db option "select into/bulkcopy" which could be set to "ON/TRUE" to achieve the same effect. However, since the question refered to bulk-logged and recovery models it could be assumed that it related to SQL 2000 and later.

Cheers,

Duncan
Post #1065009
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse