General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2000
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only