Restoring BCM database

[SO''B]

A "Tech" at my work uninstalled MSSQL on my laptop and I lost all my data.
Having a backup from a few days ago made me feel better - but I didn't test
it and once all of BCM was up and running I tried to restore and I get a
popup which reads "Line 1: Incorrect syntax near 'Brien'."
I have the unfortunate luck of my name being O'Brien so I guess it doesn't
like the apostrophe? What to do? It has no problem backing it up - I did it
with the new, virtually empty database and got the same message!

Outlook 2003 BCM update SP2

 

[Clinton Ford [MSFT]]

Thank you for reporting this problem.

Uninstalling MSSQL should not delete your databases. You might want to
first check to see if the original database files are still on the laptop in
this folder:

C:\Documents and Settings\<user>\Local Settings\Application
Data\Microsoft\Business Contact Manager

You could also restore the database using the SQL Server osql tool by doing
the following:
1.) First backup your existing database to a different location
2.) Close Outlook, wait a minute, then check Task Manager to make sure the
OUTLOOK.EXE process has exited. (Right-click on the Windows Taskbar and
select "Task Manager")
3.) Make a copy of your original .msbcm backup file
4.) Rename the copy to end with a .zip extension
5.) Extract the file contained within the .zip file
6.) Rename the extracted file with a .BAK extension
7.) Open a command prompt and type the following commands:
osql -E -S <YourComputerName>\MICROSOFTSMLBIZ -Q "RESTORE DATABASE
<NameOfBackedUpDB> FROM DISK = 'C:\Backups\FileFromStep5.BAK' WITH REPLACE"

 

[SO''''''''B]

Cheers for the prompt reply - success. The database was there all along - I
didn't know a way to reconnect it in BCM so I used your restore process on
the backup and it worked no problem ..... lovely!