Re: what is the command to cut down the size of log file
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 05/11/04
- Next message: John Kane: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Previous message: Sue Hoegemeier: "Re: Limiting Records Returned"
- In reply to: izumi: "what is the command to cut down the size of log file"
- Next in thread: Hari: "Re: what is the command to cut down the size of log file"
- Reply: Hari: "Re: what is the command to cut down the size of log file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 May 2004 20:41:55 -0600
To physically reduce the size of the log, you can use dbcc
shrinkfile. See books online for more information on this
command.
If you need to truncate the log (not the same as reducing
the size), backup the log using backup log which is also
documented in books online.
-Sue
On Tue, 11 May 2004 10:09:07 +0800, "izumi" <test@test.com>
wrote:
>what is the command to cut down the size of log file
>
- Next message: John Kane: "Re: 'Microsoft Search service cannot be administered under the present user error' SP3"
- Previous message: Sue Hoegemeier: "Re: Limiting Records Returned"
- In reply to: izumi: "what is the command to cut down the size of log file"
- Next in thread: Hari: "Re: what is the command to cut down the size of log file"
- Reply: Hari: "Re: what is the command to cut down the size of log file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
