MS SQL Server - Shrink old files .LDF

Author

Shrink old files .LDF

WalidSQL2000

2005-08-08, 11:23 am

Dear all,
I try to reduce or shrink some .ldf files from old DDBB in my instance, but
i cant
i try to reduce with the Enterprise Manager but i cant.
I try it with the ALTER DATABASE fixes another size but it dont modify

Can some one help me

Thanks for all
Walid

Alejandro Mesa

2005-08-08, 11:23 am

INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/kb/272318/

AMB

"WalidSQL2000" wrote:

> Dear all,
> I try to reduce or shrink some .ldf files from old DDBB in my instance, but
> i cant
> i try to reduce with the Enterprise Manager but i cant.
> I try it with the ALTER DATABASE fixes another size but it dont modify
>
> Can some one help me
>
> Thanks for all
> Walid

Hari Prasad

2005-08-08, 8:23 pm

Hi,

You should backup the transaction log (Backup log dbname to
disk='d:\backup\dbna
me.trn') before doing the DBCC SHRINK command.
Incase if you do not need the transaction log backup then you can truncate
the transaction log using

Backup log <dbname> with Truncate_only

After doing either log backup or truncate log you could try Shrink. I
recommend you to DBCC SHRINKFILE to shrink
the database files

Thanks
Hari
SQL Server MVP

"WalidSQL2000" < WalidSQL2000@discuss
ions.microsoft.com> wrote in message
news:BC2B6959-D57D-4493-8A5A- C46AFA01E78D@microso
ft.com...
> Dear all,
> I try to reduce or shrink some .ldf files from old DDBB in my instance,
> but
> i cant
> i try to reduce with the Enterprise Manager but i cant.
> I try it with the ALTER DATABASE fixes another size but it dont modify
>
> Can some one help me
>
> Thanks for all
> Walid

Sponsored Links