Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction log backup fails
Message
From
31/03/2006 03:36:15
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01109435
Message ID:
01109436
Views:
22
This message has been marked as the solution to the initial question of the thread.
Check the backup model for the database is it in Full or Bulk model. If its in Simple then you cannot back up the transaction log as no transactions are written to the log.

Regards

Jon
>Hi.
>I have a management plan, which among other things backs up transction logs of three databases. The problem is that a transaction log backup procedure for one of those databases fails with the following message:
>"Backup can not be performed on this database."
>I compared the properties of the transaction logs of all the databases, they look similar. Only the size of the transaction log in question is only 1Mb.
>Thank you.
>Kamil
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform