To find archive log status | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

To find archive log status

Hi, How do you find if the archive log is set on at the MS SQL server end…..( via code ) In oracle we have the option to code :
select log_mode from v$database into :’ workspace name’ The values returned are ‘NOARCHIVELOG#%92 (switched off#%92) and ‘ARCHIVELOG#%92 (logging is on) Is their a similar option( code ) to get results from MS SQL and what are the return paramaters??? Please help
AFAIK its not possible in SQL .<br />please refer following thread :<br /><br /><a href=’′ target=’_blank’ title=’′<a target="_blank" href=></a></a><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Thank you..