Cannot Restore Database

[Bruce Holmes]

Using BCM in Outlook 2007, I've twice now lost my database after being
forced to reinstall Vista. I've searched and searched for a solution, spent
hours on the phone with tech support, there seems no solution. My Vista
Backup stopped working, so I shut down services and managed to copy the two
files MSSmallBusiness3.ldf and MSSmallBusiness3.mdf onto a back-up drive.
Now you'd think I could copy those files back into BCM, but tech tells me it
can't be done. I've tried all sorts of things trying to trick BCM into
accepting the old database or reconnect to it and have gotten nowhere.
We're talking over a thousand names lost. I'm a singer/songwriter and these
are the names of my fans. Without it I'm lost. Can anyone offer a
suggestion?
Bruce Holmes

--
www.BruceHolmes.com
(e-mail address removed)
Bruce T. Holmes
1115 Mulford Street
Evanston, IL 60202-3318

 

[Paul]

I’m experiencing the same problem after deleting my computer from server
2003 and adding again. On my computer a new profile for the domain was
created and now I cannot access the BCM 2007 previous database.

 

[Luther]

I'm experiencing the same problem after deleting my computer from server
2003 and adding again. On my computer a new profile for the domain was
created and now I cannot access the BCM 2007 previous database.






- Show quoted text -

In cases where backups won't work on Vista, it's worth trying running
Outlook as Admin to restore the backup from BCM or connect to an
existing database--attached to the sql service.

BCM backups are zip files with the Sql Server backup file.You can add
the extension .zip, and then open the file with Explorer and copy out
the backup file. The database can then be restored manually so that it
can be used with Sql tools, Access, or Excel. If it is restored to
BCM's sql instance, BCM might be able to connect to it.

 

[Bruce Holmes]

Luther,
First, thanks so much for offering your thoughts. Unfortunately, I'm not
sure how to go about implementing your suggestion.
I've got the actual database, unzipped, ready to go. All I need to do is to
connect to it. Nobody at Microsoft seems to know how to do that. It seems
to me it ought to be simple, but nobody knows how. How does one "restore it
to BCM's sql instance" so that "BCM might be able to connect to it" and how
do you do that final connect.
Bruce

 

[Luther]

Luther,
First, thanks so much for offering your thoughts.  Unfortunately, I'm not
sure how to go about implementing your suggestion.
I've got the actual database, unzipped, ready to go.  All I need to do is to
connect to it.  Nobody at Microsoft seems to know how to do that.  It seems
to me it ought to be simple, but nobody knows how.  How does one "restore it
to BCM's sql instance" so that "BCM might be able to connect to it" and how
do you do that final connect.
Bruce








- Show quoted text -

Try using a command like this to attach the database file to the sql
instance:

sqlcmd -E -S .\mssmlbiz -d master -Q"CREATE DATABASE MSSmallBusiness
ON (FILENAME = 'C:\Documents and Settings\luther\Local Settings
\Application Data\Microsoft\Business Contact Manager
\MSSmallBusiness.mdf') FOR ATTACH"

If that's succesful, run Outlook-BCM and try selecting the database.

Luther
http://beyng.blogspot.com/