|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Database LDF file
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]
|
|
|
| Hi,
I see that the .ldf file of a my database has a huge dimension.
How i can resize or delete this file so it doesn't full all my HD?
Thank Pupo
| |
| Tibor Karaszi 2002-11-29, 5:23 am |
| Check out DBCC SHRINKFILE. Also make sure you do regular BACKUP LOG.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Pupo" <123star@libero.it> wrote in message news:O55GjT5lCHA.2260@tkmsftngp07...
> Hi,
> I see that the .ldf file of a my database has a huge dimension.
> How i can resize or delete this file so it doesn't full all my HD?
> Thank Pupo
>
>
| |
| Andrew J. Kelly 2002-11-29, 8:23 am |
| In addition to that you need to either set the recovery mode to Simple or
issue regular Log backups to keep it from growing so big again.
--
Andrew J. Kelly
SQL Server MVP
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
wrote in message news:#jdG5X5lCHA.2828@tkmsftngp04...
> Check out DBCC SHRINKFILE. Also make sure you do regular BACKUP LOG.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Pupo" <123star@libero.it> wrote in message
news:O55GjT5lCHA.2260@tkmsftngp07...
> > Hi,
> > I see that the .ldf file of a my database has a huge dimension.
> > How i can resize or delete this file so it doesn't full all my HD?
> > Thank Pupo
> >
> >
>
>
| |
| Tony Arcucci 2002-11-29, 8:23 am |
| try to "shrink"...
"Pupo" <123star@libero.it> ha scritto nel messaggio
news:O55GjT5lCHA.2260@tkmsftngp07...
> Hi,
> I see that the .ldf file of a my database has a huge dimension.
> How i can resize or delete this file so it doesn't full all my HD?
> Thank Pupo
>
>
|
|
|
|
|