recovery model

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » recovery model

recovery model

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Monday, May 26, 2008 9:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

database A is in full recovery model and the log for that database is log A.
database B is in Bulk logged recovery model and the log for that database is log B

suppose a bulk operation of 2000 record is performed on both databases A and B.

Then my doubt is both logs A and B have the same information , but point in time recovery is only possible for database A and it is not possible for database B.
Plz guide me

Post #506515

Jeff Moden

Posted Monday, May 26, 2008 9:54 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

To the best of my knowledge, point of time recovery that includes bulk inserts, is possible only with FULL RECOVERY... and then only if you're backing up the log very frequently.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #506517

sandhyarao49

Posted Monday, May 26, 2008 9:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

Thanks for your answer.

I want to know whether log A and log B has the same transactions or not

Post #506519

Jeff Moden

Posted Monday, May 26, 2008 10:03 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

Maybe yes, maybe no... the Bulk Insert has to meet certain requirements to NOT be logged. Check for "Recovery Model" in Books Online for more information on the recovery models... see the following BOL url for more information on whether something get's minimally logged or not...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/bd1dac6b-6ef8-4735-ad4e-67bb42dc4f66.htm

(Past the above into the BOL url field...)

--Jeff Moden

Post #506521

« Prev Topic | Next Topic »

Permissions