Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction log backup fails
Message
De
31/03/2006 03:36:15
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01109435
Message ID:
01109436
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform