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 Removed)
Bruce T. Holmes
1115 Mulford Street
Evanston, IL 60202-3318

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.

"Bruce Holmes" wrote:

> 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 Removed)
> Bruce T. Holmes
> 1115 Mulford Street
> Evanston, IL 60202-3318
>
>
>

On Apr 9, 7:21 pm, Paul <P...@discussions.microsoft.com> wrote:
> 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.
>
>
>
> "Bruce Holmes" wrote:
> > 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
> > Br...@BruceTHolmes.com
> > Bruce T. Holmes
> > 1115 Mulford Street
> > Evanston, IL 60202-3318- Hide quoted text -
>
> - 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.

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" <(E-Mail Removed)> wrote in message
news:74678778-690e-44c5-b32f-(E-Mail Removed)...
> On Apr 9, 7:21 pm, Paul <P...@discussions.microsoft.com> wrote:
> > 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.
> >
> >
> >
> > "Bruce Holmes" wrote:
> > > 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
> > > Br...@BruceTHolmes.com
> > > Bruce T. Holmes
> > > 1115 Mulford Street
> > > Evanston, IL 60202-3318- Hide quoted text -
> >
> > - 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.

On Apr 10, 10:04*am, "Bruce Holmes" <Br...@BruceTHolmes.com> wrote:
> 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" <enown...@gmail.com> wrote in message
>
> news:74678778-690e-44c5-b32f-(E-Mail Removed)...
>
>
>
> > On Apr 9, 7:21 pm, Paul <P...@discussions.microsoft.com> wrote:
> > > 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.
>
> > > "Bruce Holmes" wrote:
> > > > 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/songwriterand
> these
> > > > are the names of my fans. *Without it I'm lost. *Can anyone offer a
> > > > suggestion?
> > > > Bruce Holmes
>
> > > > --
> > > >www.BruceHolmes.com
> > > > Br...@BruceTHolmes.com
> > > > Bruce T. Holmes
> > > > 1115 Mulford Street
> > > > Evanston, IL 60202-3318- Hide quoted text -
>
> > > - 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.- Hide quoted text -
>
> - 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/