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

point in time restore in bulk logged recovery mode Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 9:30 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:10 AM
Points: 104, Visits: 400
Hi

Can some body please suggest that is bulk logged recovery mode database restored to pint in time is any situation..please adives


Post #1476082
Posted Monday, July 22, 2013 9:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:32 AM
Points: 42, Visits: 247
Not able to understand! your question is ambiguity.
Post #1476086
Posted Monday, July 22, 2013 10:38 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 @ 3:52 AM
Points: 42,445, Visits: 35,501
Take a read through this: http://www.sqlservercentral.com/articles/Recovery+Model/89664/


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 #1476135
Posted Monday, July 22, 2013 12:34 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:10 AM
Points: 104, Visits: 400
As i understand that , it is not possible in bulk logged recovery mode for point in time restoration. But here i would like to know that ....what will be Log file size, trend of TLog backup file of bulk logged recovery database compared to a full recovery database.

What will happen if the system crashes in between a bulk operation in bulk logged recovery database..

Thanks in advance for most valuable reply..:)
Post #1476207
Posted Monday, July 22, 2013 2:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:47 AM
Points: 223, Visits: 1,718
All answers here: http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model/
Post #1476261
Posted Monday, July 22, 2013 3:42 PM


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 @ 3:52 AM
Points: 42,445, Visits: 35,501
mohan.bndr (7/22/2013)
As i understand that , it is not possible in bulk logged recovery mode for point in time restoration. But here i would like to know that ....what will be Log file size, trend of TLog backup file of bulk logged recovery database compared to a full recovery database.

What will happen if the system crashes in between a bulk operation in bulk logged recovery database..

Thanks in advance for most valuable reply..:)


Did you read the article I referenced? The one that explains that in a large amount of detail.



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 #1476295
Posted Monday, August 12, 2013 1:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:40 AM
Points: 1, Visits: 49
We can restore with full,differential and log backup files
Post #1483155
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse