Dump Transaction With Truncate Only

I currently have maintenance plans defined to run backups for all DB's. For
one specific DB I have the reovery model set to simple. When the backup runs
for this DB I am receiving the following msg in the log: Backup Failed to
Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
of the database completes successfully. There is not an error code
associated with the message. I have researched with little success. Any
thoughts as to what is occurring?
Thank you...paldba
Have you got it set to backup the transaction log as part of this
maintainence plan? As in simple mode the transaction log cannot be backed up.
"paldba" wrote:

> I currently have maintenance plans defined to run backups for all DB's. For
> one specific DB I have the reovery model set to simple. When the backup runs
> for this DB I am receiving the following msg in the log: Backup Failed to
> Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> of the database completes successfully. There is not an error code
> associated with the message. I have researched with little success. Any
> thoughts as to what is occurring?
> Thank you...paldba
|||No I do not.
"Russell" wrote:
[vbcol=seagreen]
> Have you got it set to backup the transaction log as part of this
> maintainence plan? As in simple mode the transaction log cannot be backed up.
> "paldba" wrote:
|||Seems you have a maint plan where you have included transaction log backups. and one of your
database is in simple recovery mode. You cannot perform log backup for a database in simple recovery
mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> I currently have maintenance plans defined to run backups for all DB's. For
> one specific DB I have the reovery model set to simple. When the backup runs
> for this DB I am receiving the following msg in the log: Backup Failed to
> Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> of the database completes successfully. There is not an error code
> associated with the message. I have researched with little success. Any
> thoughts as to what is occurring?
> Thank you...paldba
|||For a database set to simple recovery, you cannot backup the transaction
log - even to truncate the log (which is unnecessary). Attempting to do so
results in an error.
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:DAC6AE7F-260F-4364-8C05-5EF31B7A272F@.microsoft.com...[vbcol=seagreen]
> No I do not.
> "Russell" wrote:
backed up.[vbcol=seagreen]
DB's. For[vbcol=seagreen]
backup runs[vbcol=seagreen]
Failed to[vbcol=seagreen]
backup[vbcol=seagreen]
Any[vbcol=seagreen]
|||Thank you for your response. I have verifed several times that that
maintenance plans are not set up to perform transaction log backups. This
msg just started occurring in the logs after months of running error free.
No changes have been made to the DB or the maintenance plan.
"Tibor Karaszi" wrote:

> Seems you have a maint plan where you have included transaction log backups. and one of your
> database is in simple recovery mode. You cannot perform log backup for a database in simple recovery
> mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "paldba" <paldba@.discussions.microsoft.com> wrote in message
> news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
>
>
|||Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server? Someone is executing this
command and you need to hunt that person down and ask why...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...[vbcol=seagreen]
> Thank you for your response. I have verifed several times that that
> maintenance plans are not set up to perform transaction log backups. This
> msg just started occurring in the logs after months of running error free.
> No changes have been made to the DB or the maintenance plan.
> "Tibor Karaszi" wrote:
recovery[vbcol=seagreen]
|||We are running SQL Server 2000. The message that appears in the log is
occurs exactly when the maintenance plan is running. I reran the maintenance
plan a few moments ago and the same message was generated in the log.
"Tibor Karaszi" wrote:

> Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server? Someone is executing this
> command and you need to hunt that person down and ask why...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "paldba" <paldba@.discussions.microsoft.com> wrote in message
> news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
> recovery
>
>
|||Strange. I don't use maint plans myself. I can only assume that is either a bug in maint wiz, or
some really strange design decision.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:87B7E14E-EB90-433B-8F26-FDED7E1FD1A4@.microsoft.com...[vbcol=seagreen]
> We are running SQL Server 2000. The message that appears in the log is
> occurs exactly when the maintenance plan is running. I reran the maintenance
> plan a few moments ago and the same message was generated in the log.
> "Tibor Karaszi" wrote:
|||Delete and recreate the plan?
Jeff
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:87B7E14E-EB90-433B-8F26-FDED7E1FD1A4@.microsoft.com...
> We are running SQL Server 2000. The message that appears in the log is
> occurs exactly when the maintenance plan is running. I reran the
maintenance[vbcol=seagreen]
> plan a few moments ago and the same message was generated in the log.
> "Tibor Karaszi" wrote:
Someone is executing this[vbcol=seagreen]
This[vbcol=seagreen]
free.[vbcol=seagreen]
backups. and one of your[vbcol=seagreen]
for a database in simple[vbcol=seagreen]
DB's. For[vbcol=seagreen]
backup runs[vbcol=seagreen]
Failed to[vbcol=seagreen]
The backup[vbcol=seagreen]
code[vbcol=seagreen]
success. Any[vbcol=seagreen]

Dump Transaction With Truncate Only

I currently have maintenance plans defined to run backups for all DB's. For
one specific DB I have the reovery model set to simple. When the backup runs
for this DB I am receiving the following msg in the log: Backup Failed to
Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
of the database completes successfully. There is not an error code
associated with the message. I have researched with little success. Any
thoughts as to what is occurring?
Thank you...paldbaHave you got it set to backup the transaction log as part of this
maintainence plan? As in simple mode the transaction log cannot be backed up.
"paldba" wrote:
> I currently have maintenance plans defined to run backups for all DB's. For
> one specific DB I have the reovery model set to simple. When the backup runs
> for this DB I am receiving the following msg in the log: Backup Failed to
> Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> of the database completes successfully. There is not an error code
> associated with the message. I have researched with little success. Any
> thoughts as to what is occurring?
> Thank you...paldba|||No I do not.
"Russell" wrote:
> Have you got it set to backup the transaction log as part of this
> maintainence plan? As in simple mode the transaction log cannot be backed up.
> "paldba" wrote:
> > I currently have maintenance plans defined to run backups for all DB's. For
> > one specific DB I have the reovery model set to simple. When the backup runs
> > for this DB I am receiving the following msg in the log: Backup Failed to
> > Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> > of the database completes successfully. There is not an error code
> > associated with the message. I have researched with little success. Any
> > thoughts as to what is occurring?
> >
> > Thank you...paldba|||Seems you have a maint plan where you have included transaction log backups. and one of your
database is in simple recovery mode. You cannot perform log backup for a database in simple recovery
mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> I currently have maintenance plans defined to run backups for all DB's. For
> one specific DB I have the reovery model set to simple. When the backup runs
> for this DB I am receiving the following msg in the log: Backup Failed to
> Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> of the database completes successfully. There is not an error code
> associated with the message. I have researched with little success. Any
> thoughts as to what is occurring?
> Thank you...paldba|||For a database set to simple recovery, you cannot backup the transaction
log - even to truncate the log (which is unnecessary). Attempting to do so
results in an error.
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:DAC6AE7F-260F-4364-8C05-5EF31B7A272F@.microsoft.com...
> No I do not.
> "Russell" wrote:
> > Have you got it set to backup the transaction log as part of this
> > maintainence plan? As in simple mode the transaction log cannot be
backed up.
> >
> > "paldba" wrote:
> >
> > > I currently have maintenance plans defined to run backups for all
DB's. For
> > > one specific DB I have the reovery model set to simple. When the
backup runs
> > > for this DB I am receiving the following msg in the log: Backup
Failed to
> > > Complete the Command Dump Transaction xxxx With Truncate Only'. The
backup
> > > of the database completes successfully. There is not an error code
> > > associated with the message. I have researched with little success.
Any
> > > thoughts as to what is occurring?
> > >
> > > Thank you...paldba|||Thank you for your response. I have verifed several times that that
maintenance plans are not set up to perform transaction log backups. This
msg just started occurring in the logs after months of running error free.
No changes have been made to the DB or the maintenance plan.
"Tibor Karaszi" wrote:
> Seems you have a maint plan where you have included transaction log backups. and one of your
> database is in simple recovery mode. You cannot perform log backup for a database in simple recovery
> mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "paldba" <paldba@.discussions.microsoft.com> wrote in message
> news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> > I currently have maintenance plans defined to run backups for all DB's. For
> > one specific DB I have the reovery model set to simple. When the backup runs
> > for this DB I am receiving the following msg in the log: Backup Failed to
> > Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> > of the database completes successfully. There is not an error code
> > associated with the message. I have researched with little success. Any
> > thoughts as to what is occurring?
> >
> > Thank you...paldba
>
>|||Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server? Someone is executing this
command and you need to hunt that person down and ask why...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
> Thank you for your response. I have verifed several times that that
> maintenance plans are not set up to perform transaction log backups. This
> msg just started occurring in the logs after months of running error free.
> No changes have been made to the DB or the maintenance plan.
> "Tibor Karaszi" wrote:
> > Seems you have a maint plan where you have included transaction log backups. and one of your
> > database is in simple recovery mode. You cannot perform log backup for a database in simple
recovery
> > mode.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> > > I currently have maintenance plans defined to run backups for all DB's. For
> > > one specific DB I have the reovery model set to simple. When the backup runs
> > > for this DB I am receiving the following msg in the log: Backup Failed to
> > > Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> > > of the database completes successfully. There is not an error code
> > > associated with the message. I have researched with little success. Any
> > > thoughts as to what is occurring?
> > >
> > > Thank you...paldba
> >
> >
> >|||We are running SQL Server 2000. The message that appears in the log is
occurs exactly when the maintenance plan is running. I reran the maintenance
plan a few moments ago and the same message was generated in the log.
"Tibor Karaszi" wrote:
> Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server? Someone is executing this
> command and you need to hunt that person down and ask why...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "paldba" <paldba@.discussions.microsoft.com> wrote in message
> news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
> > Thank you for your response. I have verifed several times that that
> > maintenance plans are not set up to perform transaction log backups. This
> > msg just started occurring in the logs after months of running error free.
> > No changes have been made to the DB or the maintenance plan.
> >
> > "Tibor Karaszi" wrote:
> >
> > > Seems you have a maint plan where you have included transaction log backups. and one of your
> > > database is in simple recovery mode. You cannot perform log backup for a database in simple
> recovery
> > > mode.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > > news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> > > > I currently have maintenance plans defined to run backups for all DB's. For
> > > > one specific DB I have the reovery model set to simple. When the backup runs
> > > > for this DB I am receiving the following msg in the log: Backup Failed to
> > > > Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
> > > > of the database completes successfully. There is not an error code
> > > > associated with the message. I have researched with little success. Any
> > > > thoughts as to what is occurring?
> > > >
> > > > Thank you...paldba
> > >
> > >
> > >
>
>|||Strange. I don't use maint plans myself. I can only assume that is either a bug in maint wiz, or
some really strange design decision.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:87B7E14E-EB90-433B-8F26-FDED7E1FD1A4@.microsoft.com...
> We are running SQL Server 2000. The message that appears in the log is
> occurs exactly when the maintenance plan is running. I reran the maintenance
> plan a few moments ago and the same message was generated in the log.
> "Tibor Karaszi" wrote:
>> Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server? Someone is executing this
>> command and you need to hunt that person down and ask why...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "paldba" <paldba@.discussions.microsoft.com> wrote in message
>> news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
>> > Thank you for your response. I have verifed several times that that
>> > maintenance plans are not set up to perform transaction log backups. This
>> > msg just started occurring in the logs after months of running error free.
>> > No changes have been made to the DB or the maintenance plan.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> > > Seems you have a maint plan where you have included transaction log backups. and one of your
>> > > database is in simple recovery mode. You cannot perform log backup for a database in simple
>> recovery
>> > > mode.
>> > >
>> > > --
>> > > Tibor Karaszi, SQL Server MVP
>> > > http://www.karaszi.com/sqlserver/default.asp
>> > > http://www.solidqualitylearning.com/
>> > >
>> > >
>> > > "paldba" <paldba@.discussions.microsoft.com> wrote in message
>> > > news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
>> > > > I currently have maintenance plans defined to run backups for all DB's. For
>> > > > one specific DB I have the reovery model set to simple. When the backup runs
>> > > > for this DB I am receiving the following msg in the log: Backup Failed to
>> > > > Complete the Command Dump Transaction xxxx With Truncate Only'. The backup
>> > > > of the database completes successfully. There is not an error code
>> > > > associated with the message. I have researched with little success. Any
>> > > > thoughts as to what is occurring?
>> > > >
>> > > > Thank you...paldba
>> > >
>> > >
>> > >
>>|||Delete and recreate the plan?
Jeff
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:87B7E14E-EB90-433B-8F26-FDED7E1FD1A4@.microsoft.com...
> We are running SQL Server 2000. The message that appears in the log is
> occurs exactly when the maintenance plan is running. I reran the
maintenance
> plan a few moments ago and the same message was generated in the log.
> "Tibor Karaszi" wrote:
> > Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server?
Someone is executing this
> > command and you need to hunt that person down and ask why...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
> > > Thank you for your response. I have verifed several times that that
> > > maintenance plans are not set up to perform transaction log backups.
This
> > > msg just started occurring in the logs after months of running error
free.
> > > No changes have been made to the DB or the maintenance plan.
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > > > Seems you have a maint plan where you have included transaction log
backups. and one of your
> > > > database is in simple recovery mode. You cannot perform log backup
for a database in simple
> > recovery
> > > > mode.
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > > > news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> > > > > I currently have maintenance plans defined to run backups for all
DB's. For
> > > > > one specific DB I have the reovery model set to simple. When the
backup runs
> > > > > for this DB I am receiving the following msg in the log: Backup
Failed to
> > > > > Complete the Command Dump Transaction xxxx With Truncate Only'.
The backup
> > > > > of the database completes successfully. There is not an error
code
> > > > > associated with the message. I have researched with little
success. Any
> > > > > thoughts as to what is occurring?
> > > > >
> > > > > Thank you...paldba
> > > >
> > > >
> > > >
> >
> >
> >|||Resolved. I deleted and redefined the plan exactly as it was and the msg's
have mysteriously disappeared. Thanks for the suggestion. Since there
weren't any changes to the maintenance plan, I didn't think to delete it.
Thanks much!
"Jeff Dillon" wrote:
> Delete and recreate the plan?
> Jeff
> "paldba" <paldba@.discussions.microsoft.com> wrote in message
> news:87B7E14E-EB90-433B-8F26-FDED7E1FD1A4@.microsoft.com...
> > We are running SQL Server 2000. The message that appears in the log is
> > occurs exactly when the maintenance plan is running. I reran the
> maintenance
> > plan a few moments ago and the same message was generated in the log.
> >
> > "Tibor Karaszi" wrote:
> >
> > > Ahh, I missed the WITH TRUNCATE_ONLY part. What version of SQL server?
> Someone is executing this
> > > command and you need to hunt that person down and ask why...
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > > news:1AFC4C74-927F-40DB-AD0C-D002E76DF3C7@.microsoft.com...
> > > > Thank you for your response. I have verifed several times that that
> > > > maintenance plans are not set up to perform transaction log backups.
> This
> > > > msg just started occurring in the logs after months of running error
> free.
> > > > No changes have been made to the DB or the maintenance plan.
> > > >
> > > > "Tibor Karaszi" wrote:
> > > >
> > > > > Seems you have a maint plan where you have included transaction log
> backups. and one of your
> > > > > database is in simple recovery mode. You cannot perform log backup
> for a database in simple
> > > recovery
> > > > > mode.
> > > > >
> > > > > --
> > > > > Tibor Karaszi, SQL Server MVP
> > > > > http://www.karaszi.com/sqlserver/default.asp
> > > > > http://www.solidqualitylearning.com/
> > > > >
> > > > >
> > > > > "paldba" <paldba@.discussions.microsoft.com> wrote in message
> > > > > news:EF18B7A5-F0CA-4925-8306-D7317C474B58@.microsoft.com...
> > > > > > I currently have maintenance plans defined to run backups for all
> DB's. For
> > > > > > one specific DB I have the reovery model set to simple. When the
> backup runs
> > > > > > for this DB I am receiving the following msg in the log: Backup
> Failed to
> > > > > > Complete the Command Dump Transaction xxxx With Truncate Only'.
> The backup
> > > > > > of the database completes successfully. There is not an error
> code
> > > > > > associated with the message. I have researched with little
> success. Any
> > > > > > thoughts as to what is occurring?
> > > > > >
> > > > > > Thank you...paldba
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>

DTS: No steps have been defined for the transformation package.

Hi,

I'm trying to run a few DTS packages in SQL Server 2000 using ASP and I'm getting the error below.

"Microsoft Data Transformation Services (DTS) Package (0x800403ED)
No steps have been defined for the transformation package."

Does anyone know all the possible reasons why this error occurs?

I've read that stop and starting the SQL service will do the trick but I've had no luck with that. I've also read that it could be a problem with disk space but I doubt that as I have more than 1GB available.

Oh...one thing I havent mentioned is that when I was doing a prototype for this...I created a new project with Visual Interdev and did all the ASP programming there to execute the package and that works fine but when I tried to incorporate the code into a different project...then that's when I get the error message above.

If anyone could help me out...that would be greatly appreciated!

Thanks.Would you please provide your code and mark which line your code is failing on ? Have you tried to access the properties of the package in your asp code as a debug measure ?|||It fails on when it calls the Execute method. All the other properties can be accessed and work.

I found out what was causing the problem and it's basically got to do with a setting in IIS (I'm using IIS 5.0). I'm not sure if this is a problem that is specific to the system I'm running here but when executing a DTS package from ASP...you have to make sure that the 'Application Protection' setting in IIS is set to 'Low (IIS Process)'. It will NOT work with any other setting.

Hope this helps.