|
Home > Archive > MS SQL Server > January 2006 > Transactional logs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transactional logs
|
|
| Kanwar 2006-01-18, 8:23 pm |
| 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
| |
| P. Ward 2006-01-18, 8:23 pm |
| 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
"Kanwar" wrote:
> 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
|
|
|
|
|