March 4, 2010 at 10:17 pm
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
March 4, 2010 at 10:24 pm
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 10:33 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply