Database maintenance plan: .trn file not backed up

We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" module
See my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module
|||Do not use the daily plan but use the weekly and tick all seven days if need be. For some reason 'Daily' is not quite what it seems, as it is more of a 'one off' than a schedule.

Database maintenance plan: .trn file not backed up

We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module|||Do not use the daily plan but use the weekly and tick all seven days if need
be. For some reason 'Daily' is not quite what it seems, as it is more of a
'one off' than a schedule.

Database maintenance plan: .trn file not backed up

We have installed an SQL 2000 database over a Windows 2000
server platform. We have used the database maintenance
plan wizard to back up three databases on a daily basis.
We have been able to back up the .BAK files, but not
the .TRN files. In addition, a failure message has been
generated to the SQthe "Jobs" moduleSee my reply to your post int he other group. Please don't multipost.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"apm2524" <anonymous@.discussions.microsoft.com> wrote in message
news:8fd901c432fb$ce8ca380$a101280a@.phx.gbl...
> We have installed an SQL 2000 database over a Windows 2000
> server platform. We have used the database maintenance
> plan wizard to back up three databases on a daily basis.
> We have been able to back up the .BAK files, but not
> the .TRN files. In addition, a failure message has been
> generated to the SQthe "Jobs" module

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?
I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegr oups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>
|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the owner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up your plan...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.

Database Maintenance Plan

A previous employee created the plan t0 back up TRN and BAK files.
When the previous employees account is removed I get an event log that
the TRN backup failed because it could not verify that the previous
users ID had access to backup point. In the Enterprise Manager I see
the plan, but am not sure how to associate it with a different login.
Do I have to recreate the plan under my id, or is there a way I can
have it run under my ID?I don't think you can change the plan owner, but you can try changing the ow
ner of each job that the
plan created... I haven't tried this myself, so worst case, it will mess up
your plan...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<natas234@.yahoo.com> wrote in message news:1127407000.465696.229780@.g49g2000cwa.googlegroups
.com...
>A previous employee created the plan t0 back up TRN and BAK files.
> When the previous employees account is removed I get an event log that
> the TRN backup failed because it could not verify that the previous
> users ID had access to backup point. In the Enterprise Manager I see
> the plan, but am not sure how to associate it with a different login.
> Do I have to recreate the plan under my id, or is there a way I can
> have it run under my ID?
>|||That was it. Changed job owner and force fired them off and confirmed
backup location contained new files. Thanks.