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.
Showing posts with label previous. Show all posts
Showing posts with label previous. Show all posts
Thursday, March 8, 2012
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.
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.
Wednesday, March 7, 2012
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.
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.
Subscribe to:
Posts (Atom)