"ritta_rex" <rittarex@discussions.microsoft.com> wrote in message
news:45E06608-35EB-41CE-B473-4CDD81E2DF13@microsoft.com...
> hi,
>
> I have this scenario :
>
> My log is full, and nobody can writte into the db, how can I clean it ?
> (recovery model is full and I have a backup of log before this problem)
>
> Do you know the steps ?
>
> regards,
>
>
> --
> ritta_rex

"Hari Prasad" wrote:

> Hi,
>
> Execute the below command to get the log size and usage
>
> DBCC SQLPERF(LOGSPACE)
>
> The problem can occur due to:-
>
> 1. LDF file is restricted to a specific size and file is grown to that limit
> 2. LDF growth is unrestricted and Hard disk (where LDF resides) is full
>
> Verify both. Incase if the physical LDF is grown very high use DBCC
> SHRINKFILE command to shrink the file to a smaller size
>
> Thanks
> Hari
> SQL Server MVP
>
> "ritta_rex" <rittarex@discussions.microsoft.com> wrote in message
> news:45E06608-35EB-41CE-B473-4CDD81E2DF13@microsoft.com...
> > hi,
> >
> > I have this scenario :
> >
> > My log is full, and nobody can writte into the db, how can I clean it ?
> > (recovery model is full and I have a backup of log before this problem)
> >
> > Do you know the steps ?
> >
> > regards,
> >
> >
> > --
> > ritta_rex
>
>