sql server new users: That's because your database is set to 'Simple' Recovery Model.

To check the recover model of your database, run follwoing in Query
Analyzer:
SELECT DATABASEPROPERTYEX( 'YourDatabaseName' , 'recovery' )

To check the recovery model using Enterprise Manager, right-click your
database and select properties, go to Options Tab and see the Recovery model
list-box.

For more information on recovery models, read the following link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp


---
Rohtash Kapoor
http://www.sqlmantra.com



[quoted text, click to view]

When I tried to backup the log of the database, found the option for backup
log is disabled, why this happened?