cut the size of the log

I use this command but it doesnot work
cannot cut the size of the log to 2MB
DBCC SHRINKFILE(ABC_log,2)
what is the correct command actually pls?actually i want to cut the size
because it is testing environment
"izumi" <test@.test.com> wrote in message
news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> I use this command but it doesnot work
> cannot cut the size of the log to 2MB
> DBCC SHRINKFILE(ABC_log,2)
> what is the correct command actually pls?
>|||If you are using a FULL or BULK LOGGED recovery model (SELECT
SERVERPROPERTYEX ('<db name>', 'RECOVERY), you can't shrink the log file
unless you backup the transaction log or truncate it. If you are using the
SIMPLE recovery model, you can't shrink it much if there are open
transactions that happen to occupy the end of the file.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"izumi" <test@.test.com> wrote in message
news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> I use this command but it doesnot work
> cannot cut the size of the log to 2MB
> DBCC SHRINKFILE(ABC_log,2)
> what is the correct command actually pls?
>|||http://www.nigelrivett.net/TransactionLogFileGrows_1.html
"izumi" wrote:
> actually i want to cut the size
> because it is testing environment
> "izumi" <test@.test.com> wrote in message
> news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> > I use this command but it doesnot work
> >
> > cannot cut the size of the log to 2MB
> >
> > DBCC SHRINKFILE(ABC_log,2)
> >
> > what is the correct command actually pls?
> >
> >
>
>|||finnaly I offline the database
go to physical path and delete the abc_log
then get back much more disk space
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%23IsFtKMXEHA.3988@.tk2msftngp13.phx.gbl...
> If you are using a FULL or BULK LOGGED recovery model (SELECT
> SERVERPROPERTYEX ('<db name>', 'RECOVERY), you can't shrink the log file
> unless you backup the transaction log or truncate it. If you are using
the
> SIMPLE recovery model, you can't shrink it much if there are open
> transactions that happen to occupy the end of the file.
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backup files? Try MiniSQLBackup
>
> "izumi" <test@.test.com> wrote in message
> news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> > I use this command but it doesnot work
> >
> > cannot cut the size of the log to 2MB
> >
> > DBCC SHRINKFILE(ABC_log,2)
> >
> > what is the correct command actually pls?
> >
> >
>|||I hope you did a backup before. This is not a safe operation, and you should consider yourself lucky
if the database isn't corrupt after the operation.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"izumi" <test@.test.com> wrote in message news:e2z8mbMXEHA.644@.tk2msftngp13.phx.gbl...
> finnaly I offline the database
> go to physical path and delete the abc_log
> then get back much more disk space
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:%23IsFtKMXEHA.3988@.tk2msftngp13.phx.gbl...
> > If you are using a FULL or BULK LOGGED recovery model (SELECT
> > SERVERPROPERTYEX ('<db name>', 'RECOVERY), you can't shrink the log file
> > unless you backup the transaction log or truncate it. If you are using
> the
> > SIMPLE recovery model, you can't shrink it much if there are open
> > transactions that happen to occupy the end of the file.
> >
> > Peter Yeoh
> > http://www.yohz.com
> > Need smaller SQL2K backup files? Try MiniSQLBackup
> >
> >
> > "izumi" <test@.test.com> wrote in message
> > news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> > > I use this command but it doesnot work
> > >
> > > cannot cut the size of the log to 2MB
> > >
> > > DBCC SHRINKFILE(ABC_log,2)
> > >
> > > what is the correct command actually pls?
> > >
> > >
> >
> >
>|||Yes i agree your point....
But this time it is testing environment...
so it is ok
next time, if it is live, i will backup
Thanks d><b
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9I4kyNXEHA.2940@.TK2MSFTNGP09.phx.gbl...
> I hope you did a backup before. This is not a safe operation, and you
should consider yourself lucky
> if the database isn't corrupt after the operation.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "izumi" <test@.test.com> wrote in message
news:e2z8mbMXEHA.644@.tk2msftngp13.phx.gbl...
> > finnaly I offline the database
> > go to physical path and delete the abc_log
> >
> > then get back much more disk space
> > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > news:%23IsFtKMXEHA.3988@.tk2msftngp13.phx.gbl...
> > > If you are using a FULL or BULK LOGGED recovery model (SELECT
> > > SERVERPROPERTYEX ('<db name>', 'RECOVERY), you can't shrink the log
file
> > > unless you backup the transaction log or truncate it. If you are
using
> > the
> > > SIMPLE recovery model, you can't shrink it much if there are open
> > > transactions that happen to occupy the end of the file.
> > >
> > > Peter Yeoh
> > > http://www.yohz.com
> > > Need smaller SQL2K backup files? Try MiniSQLBackup
> > >
> > >
> > > "izumi" <test@.test.com> wrote in message
> > > news:%23VPGv%23KXEHA.2408@.tk2msftngp13.phx.gbl...
> > > > I use this command but it doesnot work
> > > >
> > > > cannot cut the size of the log to 2MB
> > > >
> > > > DBCC SHRINKFILE(ABC_log,2)
> > > >
> > > > what is the correct command actually pls?
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi Izumi
What does 'does not work' mean? Do you get an error message? If so, what
error? Do you get any response at all? What does it say?
What version of SQL Server are you running?
Please give us more information.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"izumi" <test@.test.com> wrote in message
news:#VPGv#KXEHA.2408@.tk2msftngp13.phx.gbl...
> I use this command but it doesnot work
> cannot cut the size of the log to 2MB
> DBCC SHRINKFILE(ABC_log,2)
> what is the correct command actually pls?
>|||it means the the size of the log is kept unchanged
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:O98aR8QXEHA.1684@.tk2msftngp13.phx.gbl...
> Hi Izumi
> What does 'does not work' mean? Do you get an error message? If so, what
> error? Do you get any response at all? What does it say?
> What version of SQL Server are you running?
> Please give us more information.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "izumi" <test@.test.com> wrote in message
> news:#VPGv#KXEHA.2408@.tk2msftngp13.phx.gbl...
> > I use this command but it doesnot work
> >
> > cannot cut the size of the log to 2MB
> >
> > DBCC SHRINKFILE(ABC_log,2)
> >
> > what is the correct command actually pls?
> >
> >
>|||There are some links to articles regarding shrink of files for tlog at
http://www.karaszi.com/SQLServer/info_dont_shrink.asp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"izumi" <test@.test.com> wrote in message news:OeFMDCbXEHA.2940@.TK2MSFTNGP09.phx.gbl...
> it means the the size of the log is kept unchanged
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:O98aR8QXEHA.1684@.tk2msftngp13.phx.gbl...
> > Hi Izumi
> >
> > What does 'does not work' mean? Do you get an error message? If so, what
> > error? Do you get any response at all? What does it say?
> >
> > What version of SQL Server are you running?
> >
> > Please give us more information.
> >
> > --
> > HTH
> > --
> > Kalen Delaney
> > SQL Server MVP
> > www.SolidQualityLearning.com
> >
> >
> > "izumi" <test@.test.com> wrote in message
> > news:#VPGv#KXEHA.2408@.tk2msftngp13.phx.gbl...
> > > I use this command but it doesnot work
> > >
> > > cannot cut the size of the log to 2MB
> > >
> > > DBCC SHRINKFILE(ABC_log,2)
> > >
> > > what is the correct command actually pls?
> > >
> > >
> >
> >
>