Database backup using Scheduled Tasks

Database backup using Scheduled Tasks
Secure Home | Search | About
Login Password
Register Now! Lost Password?
 Microsoft Applications Security    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content add this group's latest topics to your Google content
Subject Author Date
Database backup using Scheduled Tasks Magnus.Moraberg 11-18-2008
Posted by on November 18, 2008, 8:51 am
If you were  Registered and logged in, you could reply and use other advanced thread options
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.

Posted by Pegasus \(MVP\) on November 18, 2008, 9:05 am
If you were  Registered and logged in, you could reply and use other advanced thread options

> 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.

The standard approach is to create and use a dedicated account for scheduled
tasks (e.g. "Scheduler") with a strong but non-expiring password.



Posted by Erland Sommarskog on November 18, 2008, 2:27 pm
If you were  Registered and logged in, you could reply and use other advanced thread options
(Magnus.Moraberg@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, 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/prodinfo/previousversions/books.mspx


Posted by on November 19, 2008, 11:10 am
If you were  Registered and logged in, you could reply and use other advanced thread options
> (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.

Posted by Greg D. Moore \(Strider\) on November 19, 2008, 12:06 pm
If you were  Registered and logged in, you could reply and use other advanced thread options
>> (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.



Similar ThreadsPosted
Scheduled Tasks Not Running August 11, 2006, 9:51 am
Scheduled Tasks Not Running - Error MSG Included August 11, 2006, 9:56 am
Invisible tasks? January 12, 2006, 9:13 am
Scheduled task permissions September 7, 2005, 1:06 pm
WSUS GPO setting for scheduled update June 25, 2007, 1:02 pm
Windows Defender nor running scheduled scans July 10, 2006, 9:20 am
how to lock down the SAM database? October 21, 2005, 2:22 am
Ca database maintenance July 2, 2007, 4:18 am
Problem with system account, tasks, VBScript, .NET and Components! October 17, 2006, 7:16 am
DATABASE GRATIS - www.sesso.be Popup July 10, 2005, 9:13 pm

The site map in XML format XML site map

Contact Us | Privacy Policy