+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Problem with batch backup or SIMS.net using DBAttach in Technical; Hi, I'm trying to create a .bat file to backup the SIMS.net database using the DBAttach facility. I've cribbed the ...
  1. #1

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Problem with batch backup or SIMS.net using DBAttach

    Hi,

    I'm trying to create a .bat file to backup the SIMS.net database using the DBAttach facility. I've cribbed the dbattach command from someone else's batch file but I've having trouble with the username and password. When I double click my .bat file it just shows me the Database Management Utility screen and when I click connect it says login failed for user Backup. I created user "Backup" using System Manager in SIMS.net and made this user a System Manager. Should I have created this Backup user some other way? Or does this user have to have permissions other than those of a system manager?

    Any help appreciated

  2. #2
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,987
    Thank Post
    271
    Thanked 52 Times in 46 Posts
    Blog Entries
    2
    Rep Power
    48

    Re: Problem with batch backup or SIMS.net using DBAttach

    Isn't there a dedicated backup user?

  3. #3
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,044
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: Problem with batch backup or SIMS.net using DBAttach

    This is our backup script:

    Code:
    dbattach.exe /user:"backup" /password:"password" /backup /SERVER:"server_name" /DATABASE:"sims" /AUTO
    No specific rights for the backup user.

  4. #4
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,063
    Thank Post
    69
    Thanked 80 Times in 63 Posts
    Rep Power
    36

    Re: Problem with batch backup or SIMS.net using DBAttach

    We created a dedicated "backup" user (as recommended by Capita) and use a bach file for backing up. One of their KBs explains why they think it's necessary. It isn't compulsory but we thought it more secure to use a limited SIMS user account since the password is in plain text. We also put the batch file in an area where only admins have access to.

    Our batch file is scheduled to run over night.

    I also make a copy of the Docstorage folder at the same time so that there's always a matched pair if we need to restore.

    HBJB

  5. #5

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Problem with batch backup or SIMS.net using DBAttach

    Thank you all for your replies. I checked out the capita website for the knowledge base article and found it (KB29316). I followed the instuctions for creating the user and then copied their batch file. All worked fine. Still not sure if the problem was with the user or the batch file itself, but anyway I'm happy as I've got a working backup!

  6. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    Quote Originally Posted by steve View Post

    dbattach.exe /user:"backup" /password:"password" /backup /SERVER:"server_name" /DATABASE:"sims" /AUTO

    Shouldn't the Server part have read - Server_name\Instance_name?

    EDIT - Sorry just saw the age of this thread....



SHARE:
+ Post New Thread

Similar Threads

  1. Post SIMS migration backup with BackupExec
    By ndavies in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 04:13 PM
  2. SIMS .net backup path
    By Jawloms in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2007, 04:17 PM
  3. DBATTACH exit code
    By ajbritton in forum MIS Systems
    Replies: 0
    Last Post: 24th November 2006, 12:31 PM
  4. Veritas Backup 9.1 Remote Problem
    By Grommit in forum Windows
    Replies: 8
    Last Post: 29th September 2006, 12:02 AM
  5. Backup Problem
    By Chris in forum Windows
    Replies: 4
    Last Post: 7th June 2006, 12:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •