Transaction Log back up - Simple Recovery mode

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Transaction Log back up - Simple Recovery mode

Author

Topic

jpiscit1
Posting Yak Master

130 Posts

Posted - 2004-09-03 : 08:04:55

Can the transaction log be backed up when a database is set to Recovery Model Simple? i have read conflicting information on this but most of what I read points to NO.

mr_mist
Grunnio

1870 Posts

Posted - 2004-09-03 : 08:10:23

No.

-------
Moo. :)

jpiscit1
Posting Yak Master

130 Posts

Posted - 2004-09-03 : 08:42:43

The purpose for me asking this question is due some documentation I read. We have a SQL 2K (SP3) server running McAfee EPO Agent. Their following link states we should set up the database in Simple recovery mode AND that we should set up the maintenance plan to do Transaction Log back ups.

https://knowledgemap.nai.com/phpclient/viewKDoc.aspx?externalID=McAfee_ePolicy_Orchestrator_3_5_Product_and_Reporting_Guides_Output_PGDatabase4_xml&sessionID=Registered|9907634&sliceID=&docID=KC.McAfee_ePolicy_Orchestrator_3_5_Product_and_Reporting_Guides_Output_PGDatabase4_xml&url=http://www.mcafeesecurity.com/common/media/htmmanuals/mcafee/ePolicy%20Orchestrator%203.5%20Product%20and%20Reporting%20Guides/Output/PGDatabase4.html&dialogID=9909997&docType=DOC_HDOC&userType=2&iterationID=1&docName=ePolicy%20Orchestrator%203.5%20Product%20and%20Reporting%20Guides%20-%20Perform%20regular%20maintenance%20for%20SQL%20Server%20databases&viewFrom=Main

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources