Question on Error message

Running SQL Server 2000 and new to the DBMS. Getting a consistent error
messahe on a test system
'Backup failed to complete the command EmptyTransactionLog1"
I checked the documentation, and the OS logs but no additional info.
Seems to be happening either at startup ot shortly thereafter.
Any thoughts on this?
As a newbie, one (of many) things I find a bit confusing in SQL Server
is that if someone clicked through the database...selected all
tasks...create backup etc...that that backup would not show up in a
database maintenance plan. If you go into that wizard anything already
set to run does not show.
Is there any way to determine if somebody has any type of backup taking
place on a db other than log messages?
Thanks in advance.
GerryIn Enterprise Manager, Under Management, you will find both Backup jobs and
Maintenance plans.
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...
> Running SQL Server 2000 and new to the DBMS. Getting a consistent error
> messahe on a test system
> 'Backup failed to complete the command EmptyTransactionLog1"
> I checked the documentation, and the OS logs but no additional info.
> Seems to be happening either at startup ot shortly thereafter.
> Any thoughts on this?
> As a newbie, one (of many) things I find a bit confusing in SQL Server
> is that if someone clicked through the database...selected all
> tasks...create backup etc...that that backup would not show up in a
> database maintenance plan. If you go into that wizard anything already
> set to run does not show.
> Is there any way to determine if somebody has any type of backup taking
> place on a db other than log messages?
> Thanks in advance.
> Gerry
>|||Arnie:
I don't see anything in either place. I assume that means that no
backups are taking place.
What I'm not clear on is if no backups of any type are taking
place...why am I getting the 'backup failed to complete the comand'
error message
Thanks
Gerry
Arnie Rowland wrote:[vbcol=seagreen]
> In Enterprise Manager, Under Management, you will find both Backup jobs an
d
> Maintenance plans.
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DataPro" <datapro01@.yahoo.com> wrote in message
> news:1153322062.758721.87120@.m73g2000cwd.googlegroups.com...|||Check to see if there are Maintenance Plans configured. Backup could be part
of a Maintenance Plan.
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153401613.227886.99740@.h48g2000cwc.googlegroups.com...
> Arnie:
> I don't see anything in either place. I assume that means that no
> backups are taking place.
> What I'm not clear on is if no backups of any type are taking
> place...why am I getting the 'backup failed to complete the comand'
> error message
> Thanks
> Gerry
>
> Arnie Rowland wrote:
>|||No, there aren't.
Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
command?
Arnie Rowland wrote:[vbcol=seagreen]
> Check to see if there are Maintenance Plans configured. Backup could be pa
rt
> of a Maintenance Plan.
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DataPro" <datapro01@.yahoo.com> wrote in message
> news:1153401613.227886.99740@.h48g2000cwc.googlegroups.com...|||DataPro wrote:
> No, there aren't.
> Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
> command?
>
Where are you seeing this error message? Can you post the ENTIRE error
message here?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I haven't seen or heard of such a command. I'm wondering if it is a
'comment' in a script, job, etc.
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153478749.916109.113570@.i42g2000cwa.googlegroups.com...
> No, there aren't.
> Wouldn't the command 'EmptyTransactionLog' be some kind of truncation
> command?
>
> Arnie Rowland wrote:
>|||This is the message...now repeating every 30 minutes
BACKUP failed to complete the command EmptyTransactionLog;1
It seems to happen shortly after startup and follows this notation in
the log, before just repeating itself over and over
SQL global counter collection task is created.
I did a search on the web and found one reference to this message. But
no clue on what it means.
Thanks
Gerry|||Gerry,
What service pack do you have installed?
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DataPro" <datapro01@.yahoo.com> wrote in message
news:1153765668.194365.252410@.m79g2000cwm.googlegroups.com...
> This is the message...now repeating every 30 minutes
> BACKUP failed to complete the command EmptyTransactionLog;1
> It seems to happen shortly after startup and follows this notation in
> the log, before just repeating itself over and over
> SQL global counter collection task is created.
> I did a search on the web and found one reference to this message. But
> no clue on what it means.
> Thanks
> Gerry
>|||DataPro wrote:
> This is the message...now repeating every 30 minutes
> BACKUP failed to complete the command EmptyTransactionLog;1
> It seems to happen shortly after startup and follows this notation in
> the log, before just repeating itself over and over
> SQL global counter collection task is created.
> I did a search on the web and found one reference to this message. But
> no clue on what it means.
> Thanks
> Gerry
>
Hi Gerry
It sounds like you have a job scheduled to run every 30 minutes that
does something to a logfile. It could the that it tries to backup a
logfile for a database that has been set to SIMPLE recovery.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator