Re: benefits of full recovery**

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Zarko Jovanovic (mind_less_NOSPAM__at_bigfoot.com)
Date: 11/04/04 

Date: Thu, 4 Nov 2004 08:31:41 +0100

maryam rezvani wrote:
> Hi
>
> What's the benefit usage to select Full recovery model for a database?
> I know it's better to select simple mode for developement and test
> enviroment.
> But I don't know excatly how can the full recovery model be usefull
> for critical enviroment?
>
> Can any body give me an example?
> Thanks alot

short:

if your DB is in full recovery model, you will have to backup the log, if
you can several times/day. In case of a restore, you probably will not lose
any data, and you can recovery to the point in time (useful if someone
deletes something or some other human error)

long:

see BooksOnLine (mssql help)

Relevant Pages

  • Re: benefits of full recovery**
    ... in 9:00 am and my db is in full recovery model so I can restore my db to the ... exaclty before the false insertion through the log file? ... >> What's the benefit usage to select Full recovery model for a database? ... >> But I don't know excatly how can the full recovery model be usefull ...
    (microsoft.public.sqlserver.server)
  • What is the best practice to create Maintenance Plans
    ... There is not a definitive answer to the question of which backup is better. ... the database can be recovered to the point ... Full Recovery or Bulk-Logged Recovery model. ... Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • RE: What is the best practice to create Maintenance Plans
    ... > If master is damaged in some way, for example because of media failure, an ... > With the Simple Recovery model, the database can be recovered to the point ... > Full Recovery or Bulk-Logged Recovery model. ... > Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint and SQL Recovery Model
    ... SQL Server 2000 uses recovery models to help you plan backups. ... You can use either Simply or Full Recovery Model based on your need. ... be recovered to the point of the last backup. ... The SharePoint Portal Server 2003 configuration database. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: transaction log
    ... It seems your Recovery model set to that database is "FULL". ... So we need to scdule a transaction log backup regularly (atleast hourly ...
    (microsoft.public.sqlserver.server)