SQL Server Performance Forum – Threads Archive
Truncating transaction logI 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 Crogram 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?<br /><br />MeanOldDBA<br />[email protected]<br /><br />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.
BACKUP LOG dbname
GO This is the first time i got this error