Clear log after backup

Hello everybody,
I set up a backup routine to one of my SQL-Server databases.
It´s a full backup, and I don´t know why, but the log file it´s not cleared
after the backup. I thought the full backup, when executed, would clear the
database log. Is there something missing ?
EvandroFull backups do not truncate the log. You need to issue a log backup for
that or set the recovery mode to SIMPLE.
--
Andrew J. Kelly
SQL Server MVP
"Evandro Braga" <evandro_braga@.hotmail.com> wrote in message
news:uGI4TGn9DHA.2640@.TK2MSFTNGP10.phx.gbl...
> Hello everybody,
> I set up a backup routine to one of my SQL-Server databases.
> It´s a full backup, and I don´t know why, but the log file it´s not
cleared
> after the backup. I thought the full backup, when executed, would clear
the
> database log. Is there something missing ?
>
> Evandro
>

Clear log after backup

Hello everybody,
I set up a backup routine to one of my SQL-Server databases.
Its a full backup, and I dont know why, but the log file its not cleared
after the backup. I thought the full backup, when executed, would clear the
database log. Is there something missing ?
EvandroFull backups do not truncate the log. You need to issue a log backup for
that or set the recovery mode to SIMPLE.
Andrew J. Kelly
SQL Server MVP
"Evandro Braga" <evandro_braga@.hotmail.com> wrote in message
news:uGI4TGn9DHA.2640@.TK2MSFTNGP10.phx.gbl...
> Hello everybody,
> I set up a backup routine to one of my SQL-Server databases.
> Its a full backup, and I dont know why, but the log file its not
cleared
> after the backup. I thought the full backup, when executed, would clear
the
> database log. Is there something missing ?
>
> Evandro
>

Chinese

Hi,
can anyone tell me what I have to do to use a chinese character set on SQL-Server 2000.
How are the settings on the Server and the workstations ?
We want to build a chinese version of our software and we use VB6.
regards
NielsNiels Pautke wrote:
> Hi,
> can anyone tell me what I have to do to use a chinese character set
> on SQL-Server 2000. How are the settings on the Server and the
> workstations ? We want to build a chinese version of our software
> and we use VB6.
> regards
> Niels
Use the unicode data types and store the character data as unicode to
the server within your app.
This is quite a good url
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2
k/html/intlfeaturesinsqlserver2000.asp>
--
Br,
Mark Broadbent
mcdba , mcse+i
=============