DUMP TRANSACTION

Hi !!!
What the following command do?
DUMP TRANSACTION mydatabase WITH NO_LOG
--
The Desperate Microsoft´s NewbieDesperate
It is a SQL 6.5 command equivalent to for BACKUP LOG mydatabase WITH
TRUNCATE_ONLY (which you can read about in the books online for SQL Server
if you have SQL 7 or 200).
It makes a backup of the transaction log, but doesn't record the fact that
it made the backup, and is only done when the log is so full absolutely
nothing else can be written to it. It is an emergency measure and not to be
done as part of your normal scheduled log backups.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"The Desperate Microsoft´s Newbie" <ms.newbiew@.brfree.com.br> wrote in
message news:#BxGbg23DHA.1264@.TK2MSFTNGP11.phx.gbl...
> Hi !!!
> What the following command do?
> DUMP TRANSACTION mydatabase WITH NO_LOG
>
> --
> The Desperate Microsoft´s Newbie
>
>|||Hi,
NO_LOG option is used only when you have run out of space in the database
and cannot use
DUMP TRANSACTION WITH TRUNCATE_ONLY to purge the log.
The NO_LOG option removes the inactive part of the log without making a
backup copy
of it, and it saves space by not logging the operation.
Thanks
Hari
MCDBA
"The Desperate Microsoft´s Newbie" <ms.newbiew@.brfree.com.br> wrote in
message news:#BxGbg23DHA.1264@.TK2MSFTNGP11.phx.gbl...
> Hi !!!
> What the following command do?
> DUMP TRANSACTION mydatabase WITH NO_LOG
>
> --
> The Desperate Microsoft´s Newbie
>
>