How can I move MDF and LDF files to a new PC

One of my clients' PC crashed and they did not have a copy (backup) of the Business Contact Manager Database associated with their Outlook 2007.

I was able to retirieve the MDF and LDF files, but when I move them to the new computer Outlook gives nothing but errors when trying to access BCM.

I have 20+ years in the busines so you can assume I have tried most of the basic steps like creating a new BCM DB and then renaming the old to to the new and checking ownership and permissions.  

I can only assume it has to do with the way SQL handels the security on the DB and perhaps SID and ACL attributes.

Please help.
ddwyer36Asked:
Who is Participating?
 
WizardWillCommented:
OK i have found this ... it looks very positive they to tried the above what i sent you and had an issue they cam up with another solution read the article it looks good hope this helps you

http://blog.mpecsinc.ca/2008/08/business-contact-manager-recovery-via.html

UPDATE 2008-10-15: If you get an access denied error on the attach attempt then BCM is not installed properly. Run BCM, create a new set of dbs (generally MSSmallBusiness2), and then uninstall BCM, copy the original dbs into the directory, and attach again.
0
 
WizardWillCommented:
0
 
ddwyer36Author Commented:
WizardWill,

Thanks a bunch.  I will give this a try.  I reviewed the script and it is just one very long command line.  Something does not seem right about how it will work but I'm not the expert in this area.  Keep in mind that my client never did a backup of this BCM, I am using the same domain user account on the replacement PC but the replacement is running XP Pro where as his original PC ran Vista.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ddwyer36Author Commented:
the Result.txt log is showing an access denied error.
0
 
WizardWillCommented:
ddwyer36

do you mind posting the exact error ... from the reults
0
 
ddwyer36Author Commented:
Great follow up and sussinct respone.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.