+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Restore an Autumn DB with a Spring dbAttach? in Technical; Would attaching an Autumn SIMS 7.136 Database using a Spring 7.138 release of dbAttach corrupt the database?...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    Restore an Autumn DB with a Spring dbAttach?

    Would attaching an Autumn SIMS 7.136 Database using a Spring 7.138 release of dbAttach corrupt the database?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    No, has it?

  3. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    It did. I attached the Autumn database using the new Spring dbAttach and ran dbUpgrade to update it to Spring and it failed every time and restores. dbUpgrade reports this line is failing: exec sims.db_p_grant. Tried running it in Management Studio and got various I/O errors.

    Ran dbcc checkdb('sims') with tablock, all_errormsgs, no_infomsgs in SQL management Studio and it was unable to gather information, and reported more I/O errors. I attached the same database to own Autumn system and it worked perfectly.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    You wouldn't normally have access to a spring dbattach prior to running the upgrade though would you. Shouldn't stop it working though.

    I didn't go to autumn so can't check.
    I did a restore of summer into a spring 10 setup and upgrade worked fine.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Today restored my summer 10 backup into a spring 11 setup, using it's dbattach. No problems in restore or subsequent dbupgrade to get it working. Ditto with FMS.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] DBATTACH for FMS Why different? [Solved]
    By mark-p in forum MIS Systems
    Replies: 9
    Last Post: 6th January 2011, 07:05 PM
  2. Sims DBattach zipping
    By creese in forum MIS Systems
    Replies: 7
    Last Post: 8th March 2010, 09:43 AM
  3. Error using DBAttach
    By zag in forum MIS Systems
    Replies: 3
    Last Post: 10th December 2009, 03:45 PM
  4. DBAttach
    By TechMonkey in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2009, 02:23 PM
  5. 2003 DC restore using acronis true image with universal restore
    By ranj in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 8th February 2009, 05:50 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
  •