RE: how to shrink tran-logs of databases
From: Beeeeeeeeeeeeves (Beeeeeeeeeeeeves_at_discussions.microsoft.com)
Date: 07/09/04
- Next message: Fredrik Breine: "http calls from stored procedure"
- Previous message: Beeeeeeeeeeeeves: "RE: SQL Error Messages"
- In reply to: JJ Wang: "how to shrink tran-logs of databases"
- Next in thread: Andrew J. Kelly: "Re: how to shrink tran-logs of databases"
- Reply: Andrew J. Kelly: "Re: how to shrink tran-logs of databases"
- Reply: JJ Wang: "RE: how to shrink tran-logs of databases"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 01:31:02 -0700
Don't EVER leave the transaction log on 'full' recovery - it will absolutely eat your disks. ALWAYS have the default for ALL databases to be on 'simple'.
"JJ Wang" wrote:
> hi,
>
> work on sql server 2000.
>
> I have serveral dbs that are either 'full' or 'simple',
> their tran-logs have lots of empty space in it due to one-
> time big processes, hence, I want to shrink their physical
> size down.
>
> I used the below query on several dbs, some log size got
> shrinked, some didn't shrink at all. how come? I didn't
> perform a backup log operation for any of the db before I
> run this query:
>
> use db1
> DBCC SHRINKFILE (db1_log1_logical_name)
>
> many thanks.
>
> JJ
>
- Next message: Fredrik Breine: "http calls from stored procedure"
- Previous message: Beeeeeeeeeeeeves: "RE: SQL Error Messages"
- In reply to: JJ Wang: "how to shrink tran-logs of databases"
- Next in thread: Andrew J. Kelly: "Re: how to shrink tran-logs of databases"
- Reply: Andrew J. Kelly: "Re: how to shrink tran-logs of databases"
- Reply: JJ Wang: "RE: how to shrink tran-logs of databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
