Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to backup transaction log
Message
 
 
To
02/06/2005 09:39:08
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01019340
Message ID:
01019351
Views:
16
This message has been marked as the solution to the initial question of the thread.
>I am trying to set up regular backups of transaction logs, but on one database the transaction log backup fails. When I go to the backup window to do it manually, the 'transaction log' and 'File and Filegroup' selections are grayed out and non-selectable. I have not been able to find any database setting that precludes transaction log backups, or any differences between databases that allow transaction log backups and the one that does not.

What's recovery model for the DB in question? The Transaction log backup is unavailable for the Simple recovery model. See BOL for details.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform