Database Files to be Copied from Backup Image - No BCM Backup Data

[Jeff]

Hi,

I have spent quite a bit of time searching for an answer to this question
tonight; but, I have not had any success with the methods that I have read.

I recently had a hard drive crash (RAID1 data corruption on both drives),
only to find out that the external backups would not verify, and therefore
were only good to copy files from.

I would like to restore Business Contact Manager to the state it was in
before the disaster. (I know I should have a backup copy using BCM's utility;
but, I don't.) I was able to copy the .ldf and .mdf files which will get me
pretty close.

I am running Outlook 2007 with BCM on a 32 bit Vista workstation (i.e.
stand-alone) machine.

I know that restoring BCM via the files isn't just a matter of
cut-and-paste; but, I am confused by the SQL database references and other
details. I am fine with the details; but, I am afraid I may misunderstand
instructions which are intended for another system or circumstance.

I have tried starting a new BCM database, then shutting down Outlook,
followed by stopping the SQL server for BCM, then renaming the .ldf and .mdf
files from the previous system state to the new database name, restarting the
SQL server, and then restarting Outlook. When I attempt to view the database
information, I am told that access is denied (Error 5).

Am I making this harder than it needs to be?

In case I confused the real issue... I want to be able to use the older
database (from about 2 weeks ago) in place of the database I created tonight.

Any help would be greatly appreciated.

Thanks

Jeff

 

[DL]

Not an answer I know, but have you asertained what caused this data
corruption? I would be a shame to reconfigure only to suffer corruption
again

 

[Jeff]

Hi DL,

The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk.
It rendered my system unbootable.

Jeff

 

[Luther Blissett]

Hi DL,

The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk..
It rendered my system unbootable.

Jeff






- Show quoted text -

If you've rebuilt the machine, even if you have the same user and
password, but don't have a domain controller (i.e. you have a
workgroup LAN), then Windows won't think you are the same user. I
believe what happens is that Windows generates an ID when you create a
new user, and Sql Server won't consider this new user the same as the
user that backed-up the database.

What you need to do is make your user have full permission on sql
server -- the default if you installed Sql. Then you need to attach
the bcm database (the MDF file) to BCM sql instance (MSSMLBIZ). You
can use Sql Management Studio to do that. Then once mounted, you need
to take ownership of the database, and then BCM be able to connect to
the database without permission errors.

The sql command for taking ownership of a database has been discussed
before. You should be able to find the sql sommand for doing so by
searching this group.

 

[Jeff]

Hi Luther,

Thanks for your reply.

I will search for the topic you discussed. Thank you.

This morning when I opened Outlook, I received a slightly different set of
messages. Today I was told that BCM could not connect to the shared database
and asked if I wanted to work offline. When I said no, Outlook completed
loading; but, there was no drop-down for BCM. Maybe it is part of the same
problem, or not. I thought I would at least post this since you were kind
enough to respond to my original post.

Take Care

Jeff

 

[Jeff]

Hi Luther,

I want to make sure I download the correct program.

Is it "Microsoft SQL Server Management Studio Express" that I want to
download, or is it "Microsoft SQL Server Management Studio". I can find a
link to download the express version. I just don't want to install (or
attempt to install) the wrong application.

Thanks

Jeff