|
Home > Archive > Commerce Server General > July 2005 > Log file size increasing fast - assistance please
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Log file size increasing fast - assistance please
|
|
|
| Hi All,
I have a CS2002 installation and everything is fine. However, i have noticed
over the last 2 months my Free space on my Hard Disk Drive is being eaten up
faster than normal. I have checked and come across inthe SQL DATA folder a
file called Retail_commerce_log.ldf that is almost 60Gb in size.
Can someone tell me how I can Reduce the size of this database and also to
figureout why it has suddenly started increase in size.
I have looked at the Microsoft website and all the newsgroups, but I don't
see any reference to this database file.
Thanks you.
| |
| Zoe Hart [MVP] 2005-07-05, 7:48 am |
| This is basically a database maintenance issue. A SQL Server database logs
transactions for recovery purposes. The best thing to do is to establish a
database maintenance plan that ensures full backups of your database and the
logs. When the database logs are backed up, SQL Server will truncate the
log. We normally set our databases to backup nightly, sometimes more often
for the transaction logs. But if your main concern is to reduce the size of
the log, nightly should do the trick. Do you have a DBA for your databases.
If you do you should ask why these backups aren't already being done for
recovery purposes. The first time you back up the logs, you may need enough
free space to backup your already bloated log file. After that, if you back
it up nightly and set the maintenance plan to delete older backups, you'll
eventually get that space back.
--
Zoe Hart
Commerce Server MVP
"4pcd" <4pcd@discussions.microsoft.com> wrote in message
news:6BB40600-A5A3-4F96-97A1-7A1025B250E9@microsoft.com...
> Hi All,
>
> I have a CS2002 installation and everything is fine. However, i have
> noticed
> over the last 2 months my Free space on my Hard Disk Drive is being eaten
> up
> faster than normal. I have checked and come across inthe SQL DATA folder a
> file called Retail_commerce_log.ldf that is almost 60Gb in size.
>
> Can someone tell me how I can Reduce the size of this database and also to
> figureout why it has suddenly started increase in size.
>
> I have looked at the Microsoft website and all the newsgroups, but I don't
> see any reference to this database file.
>
> Thanks you.
|
|
|
|
|