log file getting larger**

Hi
I'm working with SQL server 2000
and I have a question about maintenancing a db:
I have dat and log files located in D: drive
and my drive was getting full and specially the
size of db's log file is larger,to solve
my problem I added another log file which is located in
another drive with more free space,and I shrink the
db periodically,
Now,Is there another way to prevent getting the db
larger (for example someway to clear some old information
of log file) ?
or another ways?
any help would be greatly thankful.
Hi,
How to shrink the existing log file:
1. Perform a Transaction log backup (BACKUP LOG - refer books online)
2. Use DBCC SHRINKFILE on trasnaction log file
Have a look into the below link;
http://support.microsoft.com/default...;EN-US;q272318
Check the Recovery model you are using for that database. If it is FULL and
your data is not critical then change the Recovery model to SIMPLE. Simple
recovery model will clear the Transaction log after commiting.
If you need the recovery model as FULL then,
Schedule a Transaction log backup based on your data growth, This can be
used when point in time recovery.
This will ensure that ur log file wont gow much.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsapfoztqhqligo@.msnews.microsoft.com...
> Hi
> I'm working with SQL server 2000
> and I have a question about maintenancing a db:
> I have dat and log files located in D: drive
> and my drive was getting full and specially the
> size of db's log file is larger,to solve
> my problem I added another log file which is located in
> another drive with more free space,and I shrink the
> db periodically,
> Now,Is there another way to prevent getting the db
> larger (for example someway to clear some old information
> of log file) ?
> or another ways?
> any help would be greatly thankful.
>
|||RM
If you don't cary about the data you can set recovery mode to SIMPLE
,otherwise do a regular BACKUP LOG in order to keep the size of the log and
a possibility recover the data at point of time.
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsapfoztqhqligo@.msnews.microsoft.com...
> Hi
> I'm working with SQL server 2000
> and I have a question about maintenancing a db:
> I have dat and log files located in D: drive
> and my drive was getting full and specially the
> size of db's log file is larger,to solve
> my problem I added another log file which is located in
> another drive with more free space,and I shrink the
> db periodically,
> Now,Is there another way to prevent getting the db
> larger (for example someway to clear some old information
> of log file) ?
> or another ways?
> any help would be greatly thankful.
>
|||Hi,
If it's SQL Server Ent. Edition default db recovery model is full, so when you create a new database it is always in full recovery model. So if you don't need point in time recovery and your db is not a mission critical OLTP database i recommend you to ch
ange the recovery model to simple.
If not then perform a regular log backups. And i recommend you to seperate log file to another physical disk partition.
Adjust your log file size to appopriate size to keep virtual log file number as low as possible.
Regards..
"RM" wrote:

> Hi
> I'm working with SQL server 2000
> and I have a question about maintenancing a db:
> I have dat and log files located in D: drive
> and my drive was getting full and specially the
> size of db's log file is larger,to solve
> my problem I added another log file which is located in
> another drive with more free space,and I shrink the
> db periodically,
> Now,Is there another way to prevent getting the db
> larger (for example someway to clear some old information
> of log file) ?
> or another ways?
> any help would be greatly thankful.
>