T-Log Backup

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
T-Log Backup

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

August 11th, 2005, 03:58 AM

koushikroy2001 koushikroy2001 is offline

Registered User

Join Date: Aug 2005

Posts: 5

Thanks: 0

Thanked 0 Times in 0 Posts

T-Log Backup

Hi,

Can anyone pls help on this..

While I am trying to take Transaction Log backup with Truncate_only statemnt, i am getting some error..

Command given:

backup log databasename to disk='d:\Tlog.bak'
with truncate_only

Error:
One or more of the options (dump device) are not supported for this statement. Review the documentation for supported options.

Pls help on this..

koushikroy

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create backup folder & also backup files	miracles	Excel VBA	0	April 16th, 2007 02:28 AM
Backup Log Files out of order	khautinh	SQL Server 2000	2	March 16th, 2007 01:41 AM
backup transaction log file	rohit_sant	SQL Server 2000	3	September 26th, 2006 11:09 AM
AppException Class -Log Error to Event Log	bekim	BOOK: ASP.NET Website Programming Problem-Design-Solution	7	December 7th, 2004 01:01 PM
Backup Tx log	vincentc	SQL Server 2000	0	September 15th, 2003 08:42 PM