1. Ensure that you are using the latest SQL Server service pack. SELECT @@VERSION 2. Ensure that you have the appropriate permissions to make a backup/restore. To backup a database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin fixed server role, or of the db_owner or db_backup operator fixed database roles. To restore a database, you should have CREATE DATABASE permissions if the database being restored does not exist. If the database being restored does exist, you should have RESTORE permissions granted to you, or you should be a member of the sysadmin or dbcreator fixed server roles, or you need to be the owner (dbo) of the database. 3. If you want to make a backup of the transaction log, check that the 'trunc. log on chkpt' option is turned off. You cannot make a backup of the transaction log if the 'trunc. log on chkpt' option is turned on, because...
~ a resource for the Microsoft SQL Server.