Re: recover mode and the transaction log file question

From: Kent Eilers (kent_at_kaeServices.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 15:49:22 GMT

woot !!

doing the backup after the recovery mode change did the trick - I now have a
full T-log.

Thanks both of you for your replies

"Kent Eilers" <kent@kaeServices.com> wrote in message
news:shlec.33467$YC5.30597@twister.rdc-kc.rr.com...
> It's been about seven years since i've worked with SQL Server...(ouch) and
> I"ve been playing around with it on my home PC.
>
> My goal is to get the transaction log filled. I've reviewed the new
> 'recovery mode' options and have set the recovery mode for my test
database
> to 'full' with the following command:
>
> <alter database leads set recovery full>
>
> I have setup the log file to not grow at all. It is set at 3 MB.
>
> I then have added records into a table with an insert statement.
>
> I check the log file status using the "DBCC SQLPERF(logspace)" command
> after every insert.
>
> I can get the 'log file' full message triggered if I insert a large enough
> batch. If I insert smaller amounts of data the log space fluxuates -up
and
> down! It maxes out in the 60 - 70 % full then is at 20% after the next
> insert!
>
> It this the correct behavior given the recovery mode/T-log parameters I've
> mentioned above? If so what am I missing here? It seems like the
database
> is doing automatic truncate log commands behind my back - but nothing of
the
> sort is being logged in the SQL Server log files.
>
> Any feedback much appreciated.
>
> --
> kent eilers
> kent@kaeServices.com
>
>

Relevant Pages

  • Re: Humongous transaction LOG!!!
    ... I did try to truncate but it didn't work. ... This is strange since the size of the backup database is about 20MB. ... I don't think that the actual size of the log file is 17GB, ... you can set the database to Simple Recovery Mode and the updates to ...
    (microsoft.public.sqlserver.server)
  • Re: recover mode and the transaction log file question
    ... Sounds like you didn't get the recovery mode set properly for some reason. ... <alter database leads set recovery full> ... > I have setup the log file to not grow at all. ... > I check the log file status using the "DBCC SQLPERF" command ...
    (microsoft.public.sqlserver.programming)
  • Re: initial size of LOG
    ... is the database in full recovery mode? ... Put the database into Simple recovery mode... ... MSDB issues... ... the DB and Log file that you reindex or defrag all the MSDB tables. ...
    (microsoft.public.sqlserver.server)
  • Re: Question on LDF file size
    ... It depends on what Recovery Mode your Database is set too. ... Transactions are in progress. ... committed to the Database the Log File will decrease in size to it ...
    (microsoft.public.sqlserver)
  • Re: Humongous transaction LOG!!!
    ... backing up or truncating the log. ... If your database is in Full or Bulk Logged ... Recovery Mode, the log file will record every update to the database, ...
    (microsoft.public.sqlserver.server)
Loading