|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > SQL Server Log Files
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 |
SQL Server Log Files
|
|
| Ats @ w**k 2002-11-29, 3:23 am |
| Hi there,
I am running a SQL Server 2000 machine at work which contains a database =
for an application we are developing. My .MDF file is 13,311,424 KB in =
size while my .LDF file is a whopping 65,291,008 KB in size. Is there a =
reason why the LDF file is so big and is there anything I can do or even =
need to do to reduce its size?
TIA :-)
--=20
Allen
When Johnny comes marching home again
He's coming by bus or underground
A womans eye will shed a tear, to see his face so beaten in fear
It was just around the corner in the English Civil War
| |
| Tibor Karaszi 2002-11-29, 3:23 am |
| SQL Server log all modifications and remove inactive log records from the physical log files
when you backup the log. So you probably had a lot of auto grow occurring for the log. Use DBCC
SHRINKFILE to reduce physical file size...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Ats @ w**k" <ats@ntalk.org> wrote in message news:as7amh.1bk.1@news.dannytuppeny.com...
Hi there,
I am running a SQL Server 2000 machine at work which contains a database for an application we
are developing. My .MDF file is 13,311,424 KB in size while my .LDF file is a whopping
65,291,008 KB in size. Is there a reason why the LDF file is so big and is there anything I can
do or even need to do to reduce its size?
TIA :-)
--
Allen
When Johnny comes marching home again
He's coming by bus or underground
A womans eye will shed a tear, to see his face so beaten in fear
It was just around the corner in the English Civil War
|
|
|
|
|