Prev: UPDATE [table] WITH (PAGLOCK) xx OPTION (SHRINKDB PLAN)
Next: Next Greater Value after Min
From: bob123 on 20 May 2010 16:03
Hi,

I have a question about model recovery:

if I am in "simple recovery model"
I can't backup my T-log
it is backuped only during a backup database
so my T-log can be very big
between to database backups

am I right ?

Thanks in advance


From: Tom Moreau on 20 May 2010 16:16
Your log will be truncated automatically about every minute or so. When you
do a full backup, the entire DB is backed up, including any contents of the
log. However, a full backup does not truncate the log. In the simple
recovery model, the biggest the log is going to be is roughly the size of
your largest transaction.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"bob123" <bob123(a)gmail.com> wrote in message
news:4bf59574$0$14578$426a74cc(a)news.free.fr...
Hi,

I have a question about model recovery:

if I am in "simple recovery model"
I can't backup my T-log
it is backuped only during a backup database
so my T-log can be very big
between to database backups

am I right ?

Thanks in advance


From: bob123 on 22 May 2010 01:52
> Your log will be truncated automatically about every minute or so

OK thanks Tom
I didn't know that
have you more information about that (link)
this is done by checkpoint ?


From: Tibor Karaszi on 22 May 2010 02:26
http://technet.microsoft.com/sv-se/library/cc966500(en-us).aspx

Above is a good overview on how I/O etc is handled in SQL Server.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"bob123" <bob123(a)gmail.com> wrote in message
news:4bf77100$0$32066$426a74cc(a)news.free.fr...
>> Your log will be truncated automatically about every minute or so
>
> OK thanks Tom
> I didn't know that
> have you more information about that (link)
> this is done by checkpoint ?
>
From: bob123 on 22 May 2010 07:06
OK thanks

"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> a �crit
dans le message de news: uwq55eX%23KHA.5592(a)TK2MSFTNGP02.phx.gbl...
> http://technet.microsoft.com/sv-se/library/cc966500(en-us).aspx
>
> Above is a good overview on how I/O etc is handled in SQL Server.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
>
> "bob123" <bob123(a)gmail.com> wrote in message
> news:4bf77100$0$32066$426a74cc(a)news.free.fr...
>>> Your log will be truncated automatically about every minute or so
>>
>> OK thanks Tom
>> I didn't know that
>> have you more information about that (link)
>> this is done by checkpoint ?
>>


 | 
Pages: 1
Prev: UPDATE [table] WITH (PAGLOCK) xx OPTION (SHRINKDB PLAN)
Next: Next Greater Value after Min