backup log PMSdb

to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'

with NO_TRUNCATE,NORECOVERY

Msg 3031, Level 16, State 1, Line 1

Option 'no_truncate' conflicts with option(s) 'norecovery'. Remove the conflicting option and reissue the statement.

backup log PMSdb

to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'

with NORECOVERY

Msg 3101, Level 16, State 2, Line 1

Exclusive access could not be obtained because the database is in use.

Msg 3013, Level 16, State 1, Line 1

BACKUP LOG is terminating abnormally.