Logging Status
Hi folks, Is there any command that can be used to obtain database logging status? Thanks a lot! Gursoy YERLI
You can go into onmonitor to find out the loggin status of your databases. Once in onmonitor, select Logical-logs and then Databases and you'll get the status of all your databases and whether or not they have logging, buffered logging, or no logging at all. Yerli Gursoy Contr 311 HSW/YAMO wrote: > Hi folks, > > Is there any command that can be used to obtain database logging status? > Thanks a lot! > > Gursoy YERLI -- Phillip Tien, DBA Whole Foods Market 512.477.5566 ext. 1226 "I always wanted to be the last guy on Earth, just to see if all those women were lying to me."
Try this script :
database sysmaster;
select
name database,
is_logging
from sysdatabases
order by name;
Regards
Hans Bosma
DBA NCCW / Almere
The Netherlands
j.bosma@nccw-casa.nl
Yerli Gursoy Contr 311 HSW/YAMO wrote in message
<7pjpnb$187$1@news.xmission.com>...
>
>Hi folks,
>
>Is there any command that can be used to obtain database logging status?
>Thanks a lot!
>
>Gursoy YERLI