diff. between simple and full recovery

Hi all,
do anyone know what is the different between simple and full recovery mode
in database properties.
thanksI suggest you search for the terms in Books Online. They are well described
there. Very short:
Full recovery mode allow you to perform transaction log backups. When you pe
rform transaction log
backup, the transaction log will be emptied.
In simple recovery mode, SQL Server will empty ("truncate) the transaction l
og for you, and
transaction log backup is not possible.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"BCat" <elin@.abcmultiactive.com> wrote in message news:ePUzahQCFHA.2384@.TK2MSFTNGP14.phx.gb
l...
> Hi all,
> do anyone know what is the different between simple and full recovery mode
> in database properties.
> thanks
>
>