About change simple recovery modle to full recovery modle

Hi Guys,
I changed simple recovery modle to full recovery modle, but I monitor ther
log file still not to be increased. IN the beginning it is increased, but
after seconds,, in go back to original. Like simples modle. Can someone tell
hwo to change it? Thanks.The log is in "auto-truncate mode" until you do a database backup of the dat
abase.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:D334D2F3-9DB4-465D-A94D-EE7F34A86B64@.microsoft.com...
> Hi Guys,
> I changed simple recovery modle to full recovery modle, but I monitor th
er
> log file still not to be increased. IN the beginning it is increased, but
> after seconds,, in go back to original. Like simples modle. Can someone te
ll
> hwo to change it? Thanks.|||Hello,
Add on to Tibor, to create the backup chain you will have to do a full
database backup after changing your recovery model from
SIMPLE to FULL. Make sure after this you schedule the transaction log backup
in frequent intervals.
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:D334D2F3-9DB4-465D-A94D-EE7F34A86B64@.microsoft.com...
> Hi Guys,
> I changed simple recovery modle to full recovery modle, but I monitor
> ther
> log file still not to be increased. IN the beginning it is increased, but
> after seconds,, in go back to original. Like simples modle. Can someone
> tell
> hwo to change it? Thanks.