circular log

Hi,
I have 2 questions:
Question 1:
I need to know what the importance of the transaction log file is. If we
shrink our transaction log regularly, then would there be any negative
effect or loss of any useful feature in MSSQL.
Question 2:
In our scenario, the transaction log grows very fast because of the heavy DB
operations, so we need to shrink the transaction file regularly. I need a
way to create a circular log file in MSSQL so that it will automatically
overwrite the transaction log file when ever it reaches the maximum limit. I
know in oracle and DB2 this feature is there, but I could not find any
satisfactory Microsoft resource which tells us how to create a circular log
file. Please help me out
Best Regards,
Abdul-Rahman.> Hi,
> I have 2 questions:
>
> Question 1:
> I need to know what the importance of the transaction log file is.
--
The transaction log allows point-in-time data recovery.
> If we shrink our transaction log regularly, then would there be any
negative
> effect or loss of any useful feature in MSSQL.
--
It is safe to truncate the transaction log regularly by backing up the
transaction log regularly.
> Question 2:
> In our scenario, the transaction log grows very fast because of the heavy
DB
> operations, so we need to shrink the transaction file regularly. I need a
> way to create a circular log file in MSSQL so that it will automatically
> overwrite the transaction log file when ever it reaches the maximum
limit. I
> know in oracle and DB2 this feature is there, but I could not find any
> satisfactory Microsoft resource which tells us how to create a circular
log
> file. Please help me out
--
There is no circular log in SQL Server. Do you need point-in-time recovery?
If not, you can use a SIMPLE RECOVERY model for your database. Or you can
keep your FULL RECOVERY MODEL and backup your transaction logs more
frequently. Backing up your transaction log will truncate it.
Hope this helps,
--
Eric Cárdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.sqlsql