+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, SIMs backup script after SQL 2005 migration failing... in Technical; After the migration to 2005 our SIMs backup script is failing with the error login failed this is the script... ...
  1. #1
    mullet_man's Avatar
    Join Date
    Oct 2005
    Location
    Oldham
    Posts
    740
    Thank Post
    35
    Thanked 48 Times in 46 Posts
    Rep Power
    28

    SIMs backup script after SQL 2005 migration failing...

    After the migration to 2005 our SIMs backup script is failing with the error login failed

    this is the script...

    @ECHO OFF
    ECHO YOUR SQL DATABASE IS CURRENTLY BEING BACKED UP, THIS MAY TAKE SEVERAL MINUTES
    DBATTACH /AUTO /BACKUP /SERVER=server\SIMS /USER=user /PASSWORD=password /DATABASE=SIMS

    I have tried to change the database to SIMS2005 but this still doesn't help. I have tried the sa user and an system manager user. both do not work.

    Any other ideas?

  2. #2

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    116

    Re: SIMs backup script after SQL 2005 migration failing...

    You typically change this bit (not the database name):

    /SERVER=server\SIMS2005

  3. #3
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 37 Times in 27 Posts
    Rep Power
    26

    Re: SIMs backup script after SQL 2005 migration failing...

    I downloaded the latest version of DBAttach.exe (v1.7 I think) and this is my command:

    "e:\SQL Server\MSSQL$SIMS\Binn\DbAttach.exe" /SERVER=SERVER /DATABASE="sims" /backup /auto /trusted /user=USER /password=PASSWORD

    This works for me.

  4. #4

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: SIMs backup script after SQL 2005 migration failing...

    hi this is probally a stupid question but is sims still available during these backups?

  5. #5
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 37 Times in 27 Posts
    Rep Power
    26

    Re: SIMs backup script after SQL 2005 migration failing...

    Yes, it seems to be. I've used this script to backup the dB during the day and not had any problems. Don't forget, this just creates a zipped backup that you'll then need to backup using your usual method.

  6. #6

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328

    Re: SIMs backup script after SQL 2005 migration failing...

    Where does dbAttach it store the backup?

  7. #7
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 37 Times in 27 Posts
    Rep Power
    26

    Re: SIMs backup script after SQL 2005 migration failing...

    Quote Originally Posted by webman
    Where does dbAttach it store the backup?
    Run SIMS System Manager - Tools - Backup Path to get the path for your system.

    It's likely to be "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\backup\" or similar.

  8. #8

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328

    Re: SIMs backup script after SQL 2005 migration failing...

    Ah, thanks Altecsole

  9. #9
    mullet_man's Avatar
    Join Date
    Oct 2005
    Location
    Oldham
    Posts
    740
    Thank Post
    35
    Thanked 48 Times in 46 Posts
    Rep Power
    28

    Re: SIMs backup script after SQL 2005 migration failing...

    Quote Originally Posted by altecsole
    I downloaded the latest version of DBAttach.exe (v1.7 I think) and this is my command:

    "e:\SQL Server\MSSQL$SIMS\Binn\DbAttach.exe" /SERVER=SERVER /DATABASE="sims" /backup /auto /trusted /user=USER /password=PASSWORD

    This works for me.
    I'll give this ago before the end of the day, thanks!!

  10. #10
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 37 Times in 27 Posts
    Rep Power
    26

    Re: SIMs backup script after SQL 2005 migration failing...

    Quote Originally Posted by mullet_man
    I'll give this ago before the end of the day, thanks!!
    If your SQL Server uses an instance you'll probably have to add this to the script (we don't use one);

    /SERVER=SERVER/INSTANCE

  11. #11
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,067
    Thank Post
    69
    Thanked 81 Times in 64 Posts
    Rep Power
    36

    Re: SIMs backup script after SQL 2005 migration failing...

    I can only get my 2005 SIMS to backup if I use the SA username and password despite using dbattach 1.7. I used to use my specially created backup user but that doesn't seem to work anymore. Not happy about having the sa password in plain text in my script.

    HBJB

  12. #12
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 37 Times in 27 Posts
    Rep Power
    26

    Re: SIMs backup script after SQL 2005 migration failing...

    Is your backup user a member of the Backup User and System Manger groups? Also, try resetting the password on the backup account, logon as the backup user and set the password and then try the script again. For some reason this kicked things into life after our upgrade. I forgot about this - sorry.

  13. #13
    mullet_man's Avatar
    Join Date
    Oct 2005
    Location
    Oldham
    Posts
    740
    Thank Post
    35
    Thanked 48 Times in 46 Posts
    Rep Power
    28

    Re: SIMs backup script after SQL 2005 migration failing...

    Quote Originally Posted by PiqueABoo
    You typically change this bit (not the database name):

    /SERVER=server\SIMS2005
    You were right, thanks PiqueABoo. Its working now. I use the SA username and password. Thanks for the tips guys.

    Stevo.

  14. #14
    kcymer's Avatar
    Join Date
    Nov 2007
    Posts
    150
    Thank Post
    4
    Thanked 9 Times in 8 Posts
    Rep Power
    16

    Re: SIMs backup script after SQL 2005 migration failing...

    You can always use build in SQL 2005 backup plan. I have it set it up for everyday @ 23.00. Working fine no problems. Output is one file *.bak.



SHARE:
+ Post New Thread

Similar Threads

  1. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 03:06 PM
  2. Post SIMS migration backup with BackupExec
    By ndavies in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 04:13 PM
  3. Failing Script.. sometimes.
    By jmair in forum Windows
    Replies: 8
    Last Post: 29th October 2007, 02:37 PM
  4. Backup failing on Exchange server 2003
    By park_bench in forum Windows
    Replies: 6
    Last Post: 21st August 2007, 05:18 PM
  5. Sims failing to load
    By snakepottery in forum Windows
    Replies: 3
    Last Post: 9th January 2006, 12:27 AM

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
  •