Switching off logging on varbinary column

17 Mar 2006 9:11 AM

Yaro

Hi

MS SQL 2005
I am familiar with another DB but in mssql I am rather newbe.

In database we have table with varchar(max) column.
Users save in this column documents, read them, sometimes change.

I am looking for solution to switch off logging operation on this column
to prevent growth of log file.

Can anybody help?

Yaro

17 Mar 2006 9:25 AM

Uri Dimant

Yaro
You cannot prevent from logging. To achive what you want , do backup log
file on regular period (every hour for example)
To reduce a physical size of the log file run DBCC SHRINKFILE command (for
details please refer to the BOL)

Show quoteHide quote

"Yaro" <yarok_delthisd***@op.pl> wrote in message
news:dvdugv$fkf$1@83.238.170.160...
> Hi
>
> MS SQL 2005
> I am familiar with another DB but in mssql I am rather newbe.
>
> In database we have table with varchar(max) column.
> Users save in this column documents, read them, sometimes change.
>
> I am looking for solution to switch off logging operation on this column
> to prevent growth of log file.
>
> Can anybody help?
>
> Yaro
>
>

17 Mar 2006 10:59 AM

Yaro

Thank you for replay
I found some information about database opion "recovery_option".
I haven't written details yet but maybe this is a way?
Yaro

Show quoteHide quote

> You cannot prevent from logging. To achive what you want , do backup log
> file on regular period (every hour for example)
> To reduce a physical size of the log file run DBCC SHRINKFILE command
> (for details please refer to the BOL)

>> Hi
>> MS SQL 2005
>> I am familiar with another DB but in mssql I am rather newbe.
>> In database we have table with varchar(max) column.
>> Users save in this column documents, read them, sometimes change.
>> I am looking for solution to switch off logging operation on this column
>> to prevent growth of log file.
>> Can anybody help?
>> Yaro

18 Mar 2006 4:10 PM

Sue Hoegemeier

No, you really can't turn off logging. The recovery model
you chose for your database doesn't mean transactions aren't
logged - it just means the logs are automatically truncated
in simple recovery mode. The log is truncated after a log
backup as Uri already suggested.
If you are in simple recovery, you can only restore back to
the last full back up so you risk data loss in the event of
needing to restore. Consequently, it's generally not
recommended for production databases.

-Sue

On Fri, 17 Mar 2006 11:59:30 +0100, "Yaro"
<yarok_delthisd***@op.pl> wrote:

Show quoteHide quote

>Thank you for replay
> I found some information about database opion "recovery_option".
>I haven't written details yet but maybe this is a way?
> Yaro
>
>> You cannot prevent from logging. To achive what you want , do backup log
>> file on regular period (every hour for example)
>> To reduce a physical size of the log file run DBCC SHRINKFILE command
>> (for details please refer to the BOL)
>
>>> Hi
>>> MS SQL 2005
>>> I am familiar with another DB but in mssql I am rather newbe.
>>> In database we have table with varchar(max) column.
>>> Users save in this column documents, read them, sometimes change.
>>> I am looking for solution to switch off logging operation on this column
>>> to prevent growth of log file.
>>> Can anybody help?
>>> Yaro
>
>