Full mode to Simple mode in SQL2000?

Hi all,
I have two DBs that set as Full mode which has a t-log and
it seems like contains some data.
These DBs are updated by clients 24/7
If I set it to Simple mode, does data from Log will be
updated to DB and truncate it automatically? And not
affect any transaction from clients?
Also, how can I see if there is any data in Transaction
log? Any Stored procedure in query analyzer?
Thanks in advance.
Lintadsl"Lintadsl" <anonymous@.discussions.microsoft.com> wrote in message
news:000f01c3a551$cd775630$a401280a@.phx.gbl...
> Hi all,
> I have two DBs that set as Full mode which has a t-log and
> it seems like contains some data.
> These DBs are updated by clients 24/7
> If I set it to Simple mode, does data from Log will be
> updated to DB and truncate it automatically?
Yes it will.
>And not affect any transaction from clients?
It will not effect any active transaction.
> Also, how can I see if there is any data in Transaction
> log? Any Stored procedure in query analyzer?
You would need a 3rd party product like lumnigent to view any data in the
transaction log. You can use DBCC OPENTRAN to see if there are any open
transactions.
You also need to be aware that if you switch the database from Full to
Simple recovery you loose the ability to recover any transactions, since the
last full database backup.
Steve|||>--Original Message--
>"Lintadsl" <anonymous@.discussions.microsoft.com> wrote in
message
>news:000f01c3a551$cd775630$a401280a@.phx.gbl...
>> Hi all,
>> I have two DBs that set as Full mode which has a t-log
and
>> it seems like contains some data.
>> These DBs are updated by clients 24/7
>> If I set it to Simple mode, does data from Log will be
>> updated to DB and truncate it automatically?
>Yes it will.
>>And not affect any transaction from clients?
>It will not effect any active transaction.
>> Also, how can I see if there is any data in Transaction
>> log? Any Stored procedure in query analyzer?
>You would need a 3rd party product like lumnigent to view
any data in the
>transaction log. You can use DBCC OPENTRAN to see if
there are any open
>transactions.
>You also need to be aware that if you switch the database
from Full to
>Simple recovery you loose the ability to recover any
transactions, since the
>last full database backup.
>Steve
>
>.
>