+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, SQL2008 Attaching+Restoring Sims Database ERROR in Technical; Hello, I have just installed a fresh install of SQL 2008 on a new server and when I try to ...
  1. #1

    Join Date
    Jun 2010
    Location
    eastbourne
    Posts
    10
    Thank Post
    13
    Thanked 2 Times in 1 Post
    Rep Power
    9

    SQL2008 Attaching+Restoring Sims Database ERROR

    Hello,

    I have just installed a fresh install of SQL 2008 on a new server and when I try to attach a database I get an error (see attachments) and when I try to restore a .bak file I get an error (see attachments).

    Anyone have any ideas to help me sort this

    Cheers
    Attached Files Attached Files

  2. #2
    DT2
    DT2 is offline
    DT2's Avatar
    Join Date
    May 2011
    Location
    Lakeville, Carleton County, New Brunswick
    Posts
    695
    Thank Post
    140
    Thanked 197 Times in 138 Posts
    Rep Power
    74
    Create a new database (rather than attach existing) then run a restore from .bak onto new DB?

    DT

  3. Thanks to DT2 from:

    ev32 (8th February 2012)

  4. #3
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    run backup on the old srever and attach that as a .bak file (bottom option)

  5. Thanks to Mcshammer_dj from:

    ev32 (8th February 2012)

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by Mcshammer_dj View Post
    run backup on the old srever and attach that as a .bak file (bottom option)
    To do this run dbattach with the /restoreui parameter. You can add it to the shortcut for future use

    But first, as DT2 said, take the clean database option from the SIMS Clean installer, then restore on top of it.

  7. 2 Thanks to vikpaw:

    DT2 (8th February 2012), ev32 (8th February 2012)

  8. #5

    Join Date
    Jun 2010
    Location
    eastbourne
    Posts
    10
    Thank Post
    13
    Thanked 2 Times in 1 Post
    Rep Power
    9
    I have just tried to create new database get this error (see attachment)
    Attached Images Attached Images

  9. #6

    Join Date
    Mar 2010
    Location
    UK
    Posts
    166
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    Have you tried rebooting - [yeah I know], but I've had dbattach failures that a reboot has solved.

  10. Thanks to Banjo from:

    ev32 (8th February 2012)

  11. #7

    Join Date
    Oct 2009
    Location
    Bournemouth
    Posts
    16
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    Noticed in the screen shot that the dbase option has been selected - it should have been the top option.

  12. Thanks to Ron_Bate from:

    ev32 (8th February 2012)

  13. #8

    Join Date
    Jun 2010
    Location
    eastbourne
    Posts
    10
    Thank Post
    13
    Thanked 2 Times in 1 Post
    Rep Power
    9
    Quote Originally Posted by Ron_Bate View Post
    Noticed in the screen shot that the dbase option has been selected - it should have been the top option.
    have tried both options get the same error on each one

  14. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Defo the top option. What more info do you get if you click 'details'?
    Which installer are you using, i guess Spring 11?
    Did the windows / sql installs all go okay?
    Actually, i should have said earlier in the other thread, but it's a great time to virtualise, which makes going back to a backup much easier and could save you time when wanting to keep retrying things like now.

  15. Thanks to vikpaw from:

    ev32 (8th February 2012)

  16. #10

    Join Date
    Jun 2010
    Location
    eastbourne
    Posts
    10
    Thank Post
    13
    Thanked 2 Times in 1 Post
    Rep Power
    9
    anyone got a link to the latest ISO?

    Cheers

  17. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by ev32 View Post
    anyone got a link to the latest ISO?Cheers
    I sent it to you yesterday, maybe it failed. Soz. This is the article you need on supportnet:KB110102

  18. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    You've got an old SIMSINST, I would go back and select the attach database later option, or just close it. Then run dbattach and restore the backup.

    @vikpaw you don't need the /restoreui switch anymore, since it went blue it's included as default

  19. Thanks to matt40k from:

    vikpaw (9th February 2012)

  20. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Cheers @matt40k - i'm still running spring 11 didn't notice the difference on my test install of autumn though.
    I was thinking he had an old setup. The new installer, should help.

  21. #14

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    ROFL!! It was included in Spring 11!! It's blue now rather that horrid Capita yellow.

  22. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by matt40k View Post
    ROFL!! It was included in Spring 11!! It's blue now rather that horrid Capita yellow.
    Yoiks! You laugh, i'm just glad i've not needed to use it on the live server. Didn't even notice anything on the test one. Just checked, and right you are, a nice shade of blue.

SHARE:
+ Post New Thread

Similar Threads

  1. Sims Database Error- any hope of recovering data?
    By philjones2000 in forum MIS Systems
    Replies: 7
    Last Post: 29th March 2010, 06:13 AM
  2. Attaching a Sims database error
    By zag in forum MIS Systems
    Replies: 5
    Last Post: 24th September 2009, 02:43 PM
  3. Sims fms6 attach database error
    By vote-for-pedro in forum MIS Systems
    Replies: 0
    Last Post: 4th March 2009, 04:40 PM
  4. Restore sims database
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 8th April 2008, 10:39 AM
  5. Can't attach new blank SIMS database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 4th July 2007, 01:49 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
  •