Database backup using Scheduled Tasks

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Magnus.Moraberg@gmail.com
    #1

    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.
    Tags: None
    • Erland Sommarskog
      #2
      Re: Database backup using Scheduled Tasks

      (Magnus.Moraber g@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@sommarsk og.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

        Comment

        • patrick61z@yahoo.com
          #3
          Re: Database backup using Scheduled Tasks

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

            Comment

            • Greg D. Moore \(Strider\)
              #4
              Re: Database backup using Scheduled Tasks

              <patrick61z@yah oo.comwrote in message
              news:15d3bec5-4cee-432d-9b7e-3898cd2b8864@d3 6g2000prf.googl egroups.com...
              On Nov 18, 2:27 pm, Erland Sommarskog <esq...@sommars kog.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.


                Comment

                • Erland Sommarskog
                  #5
                  Re: Database backup using Scheduled Tasks

                  (patrick61z@yah oo.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, esquel@sommarsk og.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

                    Comment

                    Previous template Next
                    Working...