sql server new users: Using SQLEXPRESS, is transaction logging available? Maybe I'm just not
looking in the right place...

See this url, from within SQL Server 2005's Books Online:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d7be5ac5-4c8e-4d0a-b114-939eb97dac4d.htm

Short answer is that transaction logging is always on and it is always a
write-first subsystem and it cannot be disabled.

--
TheSQLGuru
President
Indicium Resources, Inc.

[quoted text, click to view]

[quoted text, click to view]



Thank you.

Hello,

Take a look into the Recovery model topic in books onlione. FULL and
BULK_LOGGED recovery models available in all SQL Server editions logs the
transaction logs .
Make sure that you have right backup procedure to backup the logs which
helps in recovery. Fail to backup the log will cause the LDF file to grow
heavily and will result in
harddisk full and can cause downtime.

Thanks
Hari


[quoted text, click to view]