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.

re: Database backup using Scheduled Tasks

(Magnus.Moraberg@gmail.com) writes:Can't you create new user that you specify as the owner of this job?

--
Erland Sommarskog, SQL Server MVP, esquel@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

re: Database backup using Scheduled Tasks

On Nov 18, 2:27 pm, Erland Sommarskog <esq...@sommarskog.sewrote: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.

re: Database backup using Scheduled Tasks

<patrick61z@yahoo.comwrote in message
news:15d3bec5-4cee-432d-9b7e-3898cd2b8864@d36g2000prf.googlegroups.com...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.

re: Database backup using Scheduled Tasks

(patrick61z@yahoo.com) writes: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, esquel@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