UncaAlby

 Profile Answers by UncaAlby 

• Nov 3rd, 2008

 

That is a vendor-specific question.

In Sybase, you can get log file information as follows:

prompt$ isql
1> sp_help {database}
2> go

That will list the devices used by the database, including log devices.  For each log device you're interested in:

1> sp_helpdevice {device}
2> go

If the log device is an operating system file, you can get further information about that file from the operating system.

If you need to know how full the logs are for a given database, login as the "sa" user and enter:

1> use {database}
2> go
1> dbcc checktable(syslogs)
2> go

That will give you the statistics on the logging devices used by that database.