SQL Server Performance Forum – Threads Archive

Truncating transaction log

I want to truncate a log file.But when I am taking the backup of the transaction log I am getting the following error
Server: Msg 3032, Level 16, State 2, Line 1
One or more of the options (dump device) are not supported for this statement. Review the documentation for supported options.
Initially I have added a dump device for log backup in C

rogram FilesMicrosoft SQL ServerMSSQLBACKUPdump1.bak.
Pls advice what to do

Hi aaron. You have more problems. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] What version of SQL Server is this? Can you post the entire statement you’re using? Are you having this error all the time? MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

The version of this SQL server 2000 is 8.0.I have sp3 installed.
here are the stmt which I m using.
USE dbname
GO
BACKUP LOG dbname
TO devicename
WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(2,5)
GO This is the first time i got this error

]]>