|
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:
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:
> 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.
>
> > Hi DL,
> >
> > The nightmare started when I ran Diskeeper's boot-time defrag with chkdsk..
> > It rendered my system unbootable.
> >
> > Jeff
> >
> >
> >
> > "DL" wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > - Show quoted text -
> > >
> > 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
> >> > > 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-E6E129CA05BE@microsoft.com...
> >> > >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.
> > > > 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.
> > > > 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.
> > > > 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.
> > > > 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.
> > > > 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).
> > > > 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.
> > > > 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.
>
| 04 Jul 2009 | Database Files to be Copied from Backup Image - No BCM Backup Data | .Jeff |
| 05 Jul 2009 |  Re: Database Files to be Copied from Backup Image - No BCM Backup Data | .DL |
| 05 Jul 2009 |  Re: Database Files to be Copied from Backup Image - No BCM Backup | .Jeff |
| 06 Jul 2009 | Re: Database Files to be Copied from Backup Image - No BCM Backup | .Luther Blissett |
| 06 Jul 2009 |  Re: Database Files to be Copied from Backup Image - No BCM Backup | .Jeff |
| 06 Jul 2009 | Re: Database Files to be Copied from Backup Image - No BCM Backup | .Jeff |
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)
All times are in (US) Eastern Daylight Time (GMT -4:00)