SQLServerCentral.com / Administration / SQL Server 7,2000 / Recovery model from production dbases / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 22:26:37 GMT20RE: Recovery model from production dbaseshttp://www.sqlservercentral.com/Forums/Topic877371-5-1.aspxNot 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.Thu, 04 Mar 2010 22:33:57 GMTSQLRNNRRE: Recovery model from production dbaseshttp://www.sqlservercentral.com/Forums/Topic877371-5-1.aspxI 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).aspxThu, 04 Mar 2010 22:24:11 GMTHenrico BekkerRecovery model from production dbaseshttp://www.sqlservercentral.com/Forums/Topic877371-5-1.aspxHi allsome 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 advanceThu, 04 Mar 2010 22:17:23 GMTsivark1