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" <Jeff> wrote in message

news:8AAE4EB1-B3B1-4531-A6A7-E6E129CA05BE@microsoft.com...
> 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

 

[Jeff]

Re: Database Files to be Copied from Backup Image - No BCM Backup

Hi DL,

The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk.

It rendered my system unbootable.

Jeff

"DL" wrote:


> 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" <Jeff> wrote in message
> news:8AAE4EB1-B3B1-4531-A6A7-E6E129CA05BE@microsoft.com...
> > 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

>

 

[Luther Blissett]

Re: Database Files to be Copied from Backup Image - No BCM Backup

On Jul 5, 6:34 am, Jeff <J...> wrote:
> Hi DL,

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

> Jeff

> "DL" wrote:
> > 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" <J...> wrote in message
> >news:8AAE4EB1-B3B1-4531-A6A7-E6E129CA05BE@microsoft.com...
> > > 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-



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]

Re: Database Files to be Copied from Backup Image - No BCM Backup

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

"Luther Blissett" wrote:


> On Jul 5, 6:34 am, Jeff <J...> wrote:
> > Hi DL,
> > The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk..
> > It rendered my system unbootable.
> > Jeff
> > "DL" wrote:
> > > 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" <J...> wrote in message
> > >news:8AAE4EB1-B3B1-4531-A6A7-E6E129CA05BE@microsoft.com...
> > > > 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-
>

> 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]

Re: Database Files to be Copied from Backup Image - No BCM Backup

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

"Luther Blissett" wrote:


> On Jul 5, 6:34 am, Jeff <J...> wrote:
> > Hi DL,
> > The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk..
> > It rendered my system unbootable.
> > Jeff
> > "DL" wrote:
> > > 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" <J...> wrote in message
> > >news:8AAE4EB1-B3B1-4531-A6A7-E6E129CA05BE@microsoft.com...
> > > > 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-
>

> 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.
>