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

Recovery model from production dbases Expand / Collapse
Author
Message
Posted Thursday, March 4, 2010 10:17 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, January 30, 2012 6:00 AM
Points: 140, Visits: 1,010
Hi all

some of databases in our production server sql 2k is in simple recovery model

do i need to change it to full recovery?

we r using (Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.4354) )

What is the Default RecoveryModel for sql 2k & 2k5 user databases)

Thanks in advance


Post #877371
Posted Thursday, March 4, 2010 10:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
I would recommend Full on production, but read up on the different types and decide which suites your environment and needs best:
http://msdn.microsoft.com/en-us/library/aa173531(SQL.80).aspx


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #877373
Posted Thursday, March 4, 2010 10:33 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:09 PM
Points: 17,628, Visits: 15,487
Not all databases need to be in Full recovery model.

If you currently need to, or may need to in the future, be able to recover your database to a point in time - then choose full recovery model.

If the data in the database never changes or there is no need to ever recover to a point in time, then go with simple recovery.

The default recovery model will be whatever you have your MODEL database recovery model set to currently.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #877377
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse