By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Database backup using Scheduled Tasks

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
(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

P: n/a
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

P: n/a
<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

P: n/a
(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.