The NO_TRUNCATE option is also giving an error.

Example:

BACKUP LOG AdventureWorks

TO DISK ='C:\Program Files\Microsoft SQL Server\SQLWorks\Backup\adv3.bak'

WITH NO_TRUNCATE

RESULT:

Msg 942, Level 14, State 3, Line 1

Database 'AdventureWorks' cannot be opened because it is offline.

Msg 3013, Level 16, State 1, Line 1

BACKUP LOG is terminating abnormally.