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

FULL Recovery mode changed to BULK LOGGED does that break the t-log chain? Expand / Collapse
Author
Message
Posted Wednesday, January 13, 2010 3:15 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 19, 2012 4:00 PM
Points: 100, Visits: 168
Should be a quick question I hope. I've forgotten the answer. If you change a 2005 database from FULL to BULK-LOGGED recovery mode when you do your Index rebuilding and then change it back to FULL, doesn't that break the T-Log backup chain?

Thanks,
Lezza



Post #847245
Posted Wednesday, January 13, 2010 4:05 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:09 PM
Points: 4,358, Visits: 9,538
No - changing from FULL to BULK-LOGGED and back again does not break the log chain. Changing to/from SIMPLE breaks the log chain.

See the article I link to in my signature for more information on how to manage your transaction logs.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #847254
Posted Wednesday, June 22, 2011 11:42 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 12:56 PM
Points: 432, Visits: 252
If I change from full to bulk logged on replicated database (published), rebuild the indexes and change back to full.
Will it impact replication? Should I stop any of the agents before it?

I need to do it because of tran. log disk becomes full. BTW I am using SQL 2000 SP3.
Post #1129918
Posted Wednesday, June 22, 2011 11:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 40,177, Visits: 36,580
Replication does not depend in any way on recovery model.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1129921
Posted Monday, October 15, 2012 7:58 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 35, Visits: 887
I will be loading several thousand records. If I temporarily change my recovery model from FULL to BULK LOGGED, will I lose the ability to recover to a point in time?

This link seems to indicate that.

[url=http://msdn.microsoft.com/en-us/library/ms191244(v=sql.105).aspx][/url]



KU
Post #1372739
Posted Monday, October 15, 2012 8:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 40,177, Visits: 36,580
Yes, but just within the log backup interval that contains the bulk operations.

p.s. Please post new questions in a new thread in future. Thanks



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372749
Posted Monday, October 15, 2012 8:13 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 35, Visits: 887
Will do...Thanks Gail!


KU
Post #1372751
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse