PC Review


Reply
Thread Tools Rate Thread

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

 
 
Jeff
Guest
Posts: n/a
 
      5th Jul 2009
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
 
Reply With Quote
 
 
 
 
DL
Guest
Posts: n/a
 
      5th Jul 2009

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" <(E-Mail Removed)> wrote in message
news:8AAE4EB1-B3B1-4531-A6A7-(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
 
Jeff
Guest
Posts: n/a
 
      5th Jul 2009
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" <(E-Mail Removed)> wrote in message
> news:8AAE4EB1-B3B1-4531-A6A7-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
Luther Blissett
Guest
Posts: n/a
 
      6th Jul 2009
On Jul 5, 6:34*am, Jeff <J...@discussions.microsoft.com> 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...@discussions.microsoft.com> wrote in message
> >news:8AAE4EB1-B3B1-4531-A6A7-(E-Mail Removed)...
> > > 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- Hide quoted text -

>
> - 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.
 
Reply With Quote
 
Jeff
Guest
Posts: n/a
 
      6th Jul 2009
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...@discussions.microsoft.com> 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...@discussions.microsoft.com> wrote in message
> > >news:8AAE4EB1-B3B1-4531-A6A7-(E-Mail Removed)...
> > > > 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- Hide quoted text -

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

 
Reply With Quote
 
Jeff
Guest
Posts: n/a
 
      6th Jul 2009
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...@discussions.microsoft.com> 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...@discussions.microsoft.com> wrote in message
> > >news:8AAE4EB1-B3B1-4531-A6A7-(E-Mail Removed)...
> > > > 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- Hide quoted text -

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Can files copied from NTFS to FAT32 under Linux be copied back to XP? Lanwench [MVP - Exchange] Windows XP General 11 3rd Mar 2008 09:35 PM
Backup BCM database in Outlook 2003 w/BCM Mike Trout Microsoft Outlook 0 8th Mar 2007 11:16 PM
Backup BCM database in Outlook 2007 w/BCM =?Utf-8?B?Y3luZmxldGNo?= Microsoft Outlook BCM 4 28th Feb 2007 05:51 PM
BCM-V2 (Outlook 2003 BCM SP3) TO BCM-V3 (Outlook 2007) Migration =?Utf-8?B?QXJpZWw=?= Microsoft Outlook BCM 1 29th Aug 2006 02:54 PM
INSTALL BCM - uninstall BCM - install BCM - still no BCM =?Utf-8?B?RHJpeA==?= Microsoft Outlook BCM 2 9th Apr 2006 10:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:18 AM.