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 ...
24th September 2009, 11:44 AM #1
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.
IDG Tech News
24th September 2009, 11:49 AM #2
That image is filtered here, what is the error you are getting?
24th September 2009, 11:55 AM #3
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 126.96.36.199 here. Maybe I'm using an older one?
Last edited by zag; 24th September 2009 at 01:33 PM.
24th September 2009, 02:15 PM #4
- Rep Power
are you trying to attach to a remote server, i.e. SQL running on another machine?
24th September 2009, 02:38 PM #5
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
24th September 2009, 02:43 PM #6
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
By EduTech in forum EduGeek.net Site Problems
Last Post: 15th May 2009, 01:57 AM
By vote-for-pedro in forum MIS Systems
Last Post: 4th March 2009, 04:40 PM
By mloveless in forum MIS Systems
Last Post: 3rd June 2008, 03:39 PM
By TechMonkey in forum Web Development
Last Post: 2nd April 2008, 12:25 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)