467,915 Members | 1,268 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Database backup using Scheduled Tasks

Hi,

I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
Database.

This database is backed up using the following method -

http://www.sqldbatips.com/showarticle.asp?ID=27

As part of this method, I have a Task which is scheduled to run once a
day. All words fine until I need to change my password. When I am
prompted to change my password every month or so, I need to go back
into the Scheduler and update my password there also. Otherwise my
backup process will fail. How can I solve this problem?

Another problem is that I will be soon handing the database over to
another employee at the company who will then be in charge of
maintaining it. Therefore I will have to configure the Scheduler to
run from his account. I'm sure there's a better approach...

Thanks for your help,

Barry.
Nov 18 '08 #1
  • viewed: 3943
Share:
4 Replies
(Ma*************@gmail.com) writes:
As part of this method, I have a Task which is scheduled to run once a
day. All words fine until I need to change my password. When I am
prompted to change my password every month or so, I need to go back
into the Scheduler and update my password there also. Otherwise my
backup process will fail. How can I solve this problem?
Can't you create new user that you specify as the owner of this job?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 18 '08 #2
On Nov 18, 2:27 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
(Magnus.Morab...@gmail.com) writes:
As part of this method, I have a Task which is scheduled to run once a
day. All words fine until I need to change my password. When I am
prompted to change my password every month or so, I need to go back
into the Scheduler and update my password there also. Otherwise my
backup process will fail. How can I solve this problem?

Can't you create new user that you specify as the owner of this job?
Hah! I tried that at work, and the admins force password policy on the
new account as well. Still, that would be my vote too.
Nov 19 '08 #3
<pa********@yahoo.comwrote in message
news:15**********************************@d36g2000 prf.googlegroups.com...
On Nov 18, 2:27 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
> (Magnus.Morab...@gmail.com) writes:
As part of this method, I have a Task which is scheduled to run once a
day. All words fine until I need to change my password. When I am
prompted to change my password every month or so, I need to go back
into the Scheduler and update my password there also. Otherwise my
backup process will fail. How can I solve this problem?

Can't you create new user that you specify as the owner of this job?

Hah! I tried that at work, and the admins force password policy on the
new account as well. Still, that would be my vote too.
Bah... admins who force password changes every month, especially for
accounts like that, deserve to be shot.

There's far better ways to enforce security than forcing people to come up
with a new password every 30 days that they're going to end up writing down
in most cases or making non-secure.

Month_1: El3phant
Month_2: El3phant1
Month_3: El3phant2
Month_4: El3phant4
Month_5: Oh good, can go back to El3phant again.

--
Greg Moore
Ask me about lily, an RPI based CMC.
Nov 19 '08 #4
(pa********@yahoo.com) writes:
Hah! I tried that at work, and the admins force password policy on the
new account as well. Still, that would be my vote too.
Hm, can't you make a local machine account? That should not be subject
to group policy.

But if you need a service account that has to be a domain account, why
don't you talk to your admin folks?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 20 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Bart Simpson | last post: by
5 posts views Thread by Hassan Naqvi | last post: by
2 posts views Thread by mxd349 | last post: by
1 post views Thread by AquilaV | last post: by
1 post views Thread by gjiang_usenet | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.