Truncating the log
From: Paul Blackler (pblackler_at_themis.co.uk)
Date: 11/24/03
- Next message: TipTop: "what encryption is used in DTS"
- Previous message: Rich Norgaard: "sp_oacreate security execute problem"
- Next in thread: Ray Higdon: "Re: Truncating the log"
- Reply: Ray Higdon: "Re: Truncating the log"
- Reply: Paul Blackler: "Re: Truncating the log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Nov 2003 08:39:53 -0800
Hi
Just want to make sure on something.
I have a 5Gb tranactional Log and want to truncate it and
reduce it back to a bare minimum. The procedure I want to
use is as follows :-
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE (MyDatabase_Log)
IS this okay or is there anything I am missing, it seems
to work AOK. (DSS environment)
Cheers
Paul
- Next message: TipTop: "what encryption is used in DTS"
- Previous message: Rich Norgaard: "sp_oacreate security execute problem"
- Next in thread: Ray Higdon: "Re: Truncating the log"
- Reply: Ray Higdon: "Re: Truncating the log"
- Reply: Paul Blackler: "Re: Truncating the log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]