Hi,
I am running sql server 2000. I am unable to backup transactional logs
manually as the Radio button is greyed out. Any inputs why this is happening?

Thanks,
Kanwar

The Transaction Log radio button in the Backup Form launched from Enterprise
Manager is disabled (greyed out) if the database Recovery Model is Simple. 
This is as a result of BACKUP LOG not being allowed while the recovery model
is SIMPLE.

To check the database Recovery Model you can you the following TSQL
statement, replacing Northwind with the database you wish to check.

SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')


- Peter Ward
WARDY IT Solutions


Show quoteHide quote

purge all history from msdb
CPU maximums & multicore CPUs
SQL Server 2000 Enterprise Edition - how to create named instance?
SQL Backups
Sql server self locking
Cannot defragment .mdf file
profiler
Can not Create a DSN
Sql 2005 server memery
25 seconds for query on empty table (SS 2005)