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=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8939′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8939′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8939>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8939</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..
]]>