Another conflict is that BCM backup/restore zip/unzip the backup files,
but Mark also provides the OSQL instructions for restoring the
database, so you don't need to restore using BCM. The key thing in this
area is to do everything in BCM or in OSQL, but don't try to mix and
match unless you really understand what's going on
I think Mark deserves the newsgroup post of the month award. The
question has been asked fairly regularly, but usually the answer is a
terse: "Yes. Use osql." So kudos to Mark for typing in all the
instructions.
Jonathan wrote:
> Unfortunately, these instructions conflict with the BCM Backup and Restore
> functions. BCM puts restored databases back in the user's "Documents and
> Settings" folder, and the location of this can be changed only at
> installation time. Even if you move the database off C:, you'll still need
> the same free space on C: to restore it.
>
>
> "Mark Dormer" wrote:
> > To move the BCM database
> >
> > 1.Locate the MSDE database files MSBusinessContactManager.mdf and
> > MSBusinessContactManager.ldf. By default, these files are located in the
> > following folder:
> > C:\Documents and Settings\username\Local Settings\Application
> > Data\Microsoft\Business Contact Manager
> >
> > 2.Click Start, click Run, type cmd, and then press ENTER.
> >
> > 3.Start the Osql.exe tool. To do this, type osql -E -S
> > ServerName\InstanceName at the command prompt, where ServerName is the name
> > of the server where the MSDE database files are located, and where
> > InstanceName is the name of the instance of MSDE, and then press ENTER.
> >
> > Note By default, the instance name is MICROSOFTSMLBIZ
> >
> > 4.At the osql command prompt, back up the existing database. To do this,
> > type the following at the osql command prompt
> > BACKUP DATABASE MSBusinessContactManager TO DISK = 'PathName'
> > where MSBusinessContactManager is the name of the MSDE database, and where
> > PathName is the path and file name that you want, such as
> > C:\MSDE\Backup\bcm.bak.
> >
> > 5.Type GO, and then press ENTER.
> >
> > 6.Repeat steps 4 and 5 for each database if you have created any extra ones.
> > Default is just the single database.
> >
> > 7.Detach the BCM database. To do this, type EXEC sp_detach_db
> > 'MSBusinessContactManager' at the command prompt and then press ENTER.
> >
> > Note If you receive a message that the database is in use and cannot be
> > detached, start a new command prompt. At the new command prompt, type the
> > following, and then press ENTER after each line:
> >
> > net pause mssql$MICROSOFTSMLBIZ
> > net continue mssql$MICROSOFTSMLBIZ
> >
> > 8.Start another command prompt, or start Microsoft Windows Explorer, and
> > then copy both of the MSDE database files that you located in step 1 to the
> > new folder that you want.
> >
> > 9.Attach the configuration database. To do this, type the following at the
> > command prompt where the Osql.exe tool is running
> > EXEC sp_attach_db @dbname = N'MSBusinessContactManager', @filename1 =
> > N'C:\new_database_location\MSBusinessContactManager.mdf', @filename2 =
> > N'C:\new_database_location\MSBusinessContactManager.ldf'
> > where new_database_location is the folder where you moved the configuration
> > database files in step 9.
> >
> > Thats it.
> >
> >
> > Regards
> > Mark Dormer
> >
> > "WiggleRoom" <(E-Mail Removed)> wrote in message
> > news:1B5784E9-28FC-4083-B06B-(E-Mail Removed)...
> > >I need to put the Small Business Manager database on a removable drive so I
> > > can take it back and forth between work and home. Does anyone know how to
> > > set
> > > the physical location of the database?
> >
> >
> >
|
Similar Threads
