Switching off logging on varbinary column  
Author Message
ourshady2





PostPosted: Fri Mar 17 03:25:52 CST 2006 Top

SQL Server >> Switching off logging on varbinary column

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

SQL Server30  
 
 
Uri





PostPosted: Fri Mar 17 03:25:52 CST 2006 Top

SQL Server >> Switching off logging on varbinary column 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
>
>


 
 
Yaro





PostPosted: Fri Mar 17 04:59:30 CST 2006 Top

SQL Server >> Switching off logging on varbinary column 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



 
 
Sue





PostPosted: Sat Mar 18 10:10:21 CST 2006 Top

SQL Server >> Switching off logging on varbinary column 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"


>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
>
>