+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Attaching a Sims database error in Technical; I'm trying to attach a backup of our Sims database but getting the following error every time. The backup was ...
  1. #1
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93

    Attaching a Sims database error

    I'm trying to attach a backup of our Sims database but getting the following error every time.



    The backup was made with DBattach and is called .

    I've tried making a backup of the blank database, then re-attaching it and I get the same error so it must be something I'm doing wrong :/

    If I click ignore, the database is copied but It doesnt work when you try to login.
    Last edited by zag; 24th September 2009 at 02:05 PM.

  2. #2

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    470
    Thank Post
    16
    Thanked 88 Times in 80 Posts
    Rep Power
    30
    That image is filtered here, what is the error you are getting?

    Steve

  3. #3
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93
    Oh sorry,

    The error is that it cant find the .ldf file

    Error image mirror

    I'm just looking at the dbattach executable, can anyone tell me the latest version? I'm using 1.11.1.0 here. Maybe I'm using an older one?
    Last edited by zag; 24th September 2009 at 01:33 PM.

  4. #4

    Join Date
    Sep 2009
    Location
    Halesowen
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    are you trying to attach to a remote server, i.e. SQL running on another machine?

  5. #5

    Join Date
    Dec 2005
    Posts
    543
    Thank Post
    38
    Thanked 90 Times in 80 Posts
    Rep Power
    39
    When using Dbattach you do not want to have the sims.mdf and sims.ldf inside the data folder.

    The attach process will copy these file in itself.

    They need to be outside this folder somewhere

    Doh people editing their posts make mine look silly now hahaha

  6. #6
    zag
    zag is online now
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93
    Thanks guys, I think it was the /RESTOREUI thing I was missing.

    In the end I restored it using Management studio, copied the MDF and LDF, removed it from management studio. Then Attached using DBAttach and it worked correctly.

    It really would be useful if capita wrote a useful error message on dbattach for these situations(people trying to restore the .bak file) but yet again this forum has saved me

SHARE:
+ Post New Thread

Similar Threads

  1. [CLOSED] Misc: EduGeek Database Error
    By EduTech in forum EduGeek.net Site Problems
    Replies: 10
    Last Post: 15th May 2009, 01:57 AM
  2. Sims fms6 attach database error
    By vote-for-pedro in forum MIS Systems
    Replies: 0
    Last Post: 4th March 2009, 04:40 PM
  3. Attaching FMS Database
    By mloveless in forum MIS Systems
    Replies: 0
    Last Post: 3rd June 2008, 03:39 PM
  4. ASP Database error trapping
    By TechMonkey in forum Web Development
    Replies: 2
    Last Post: 2nd April 2008, 12:25 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
  •