restore database from mdf / ldf files

[Cheryl]

We upgraded 2 machines on our network from 2003 to 2007. I need to revert
back to 2003. The CEO is totally upset about this. We cannot use our BCM
right now. It said it made a backup of the bcm, which for the life of me I
cannot find. I have backups of the mdf and ldf files. I called msft and
they told me to stop the mscontactmanagersmbiz service copy the files in the
default directory and restart. Try to connect. However i have tried this on
2 other machines and it does not work. I need to go backwards to 2003. I
dont have the compressed *.msbcm file or atleast I cannot see on the drive.
Help!!!!!

Cheryl

 

[Mukesh Agarwal [MSFT]]

Look for a file with .SBB extension. If you want to restore it in 2003
again, you should be able to rename it .msbcm.

 

[Cheryl]

does not work that way. You have to restore it to 2007 bcm, export to .csv,
import into 2003 bcm and remap the files. You may lose some history but you
can relink emails. Attachments will not follow.

Look for a file with .SBB extension. If you want to restore it in 2003
again, you should be able to rename it .msbcm.

--
Mukesh Agarwal [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights

We upgraded 2 machines on our network from 2003 to 2007. I need to revert
back to 2003. The CEO is totally upset about this. We cannot use our BCM
right now. It said it made a backup of the bcm, which for the life of me
I
cannot find. I have backups of the mdf and ldf files. I called msft and
they told me to stop the mscontactmanagersmbiz service copy the files in
the
default directory and restart. Try to connect. However i have tried this
on
2 other machines and it does not work. I need to go backwards to 2003. I
dont have the compressed *.msbcm file or atleast I cannot see on the
drive.
Help!!!!!

Cheryl

 

[Clinton Ford [MSFT]]

Cheryl,

Open a command prompt and enter the following, replacing MSSmallBusiness
with a unique database name and pointing to your .mdf and .ldf files:

Vista
-----
OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db @dbname = 'MSSmallBusiness',
@filename1 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact
Manager\MSSmallBusiness.mdf', @filename2 =
'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\
MSSmallBusiness.ldf';"

Windows XP
-----------
OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db @dbname = 'MSSmallBusiness',
@filename1 = 'C:\Documents and Settings\<USER>\Local Settings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', @filename2 =
'C:\Documents and Settings\<USER>\Local Settings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.ldf';"
--
Visit team blog at http://blogs.msdn.com/bcm
This posting is provided "AS IS" with no warranties, and confers no rights

does not work that way. You have to restore it to 2007 bcm, export to .csv,
import into 2003 bcm and remap the files. You may lose some history but you
can relink emails. Attachments will not follow.

Look for a file with .SBB extension. If you want to restore it in 2003
again, you should be able to rename it .msbcm.

--
Mukesh Agarwal [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights

We upgraded 2 machines on our network from 2003 to 2007. I need to revert
back to 2003. The CEO is totally upset about this. We cannot use our BCM
right now. It said it made a backup of the bcm, which for the life of me
I
cannot find. I have backups of the mdf and ldf files. I called msft and
they told me to stop the mscontactmanagersmbiz service copy the files in
the
default directory and restart. Try to connect. However i have tried this
on
2 other machines and it does not work. I need to go backwards to 2003. I
dont have the compressed *.msbcm file or atleast I cannot see on the
drive.
Help!!!!!

Cheryl

 

[Cheryl]

I will definitely try this. By the way, do you know if there is a way to
automate the backup of BCM Ver 2 or Ver 3. We use veritas in the evirnoment
but to date have not had any luch.

Please advise. You can email me at (e-mail address removed)

Cheryl,

Open a command prompt and enter the following, replacing MSSmallBusiness
with a unique database name and pointing to your .mdf and .ldf files:

Vista
-----
OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db @dbname = 'MSSmallBusiness',
@filename1 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact
Manager\MSSmallBusiness.mdf', @filename2 =
'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\
MSSmallBusiness.ldf';"

Windows XP
-----------
OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db @dbname = 'MSSmallBusiness',
@filename1 = 'C:\Documents and Settings\<USER>\Local Settings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', @filename2 =
'C:\Documents and Settings\<USER>\Local Settings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.ldf';"
--
Visit team blog at http://blogs.msdn.com/bcm
This posting is provided "AS IS" with no warranties, and confers no rights

does not work that way. You have to restore it to 2007 bcm, export to .csv,
import into 2003 bcm and remap the files. You may lose some history but you
can relink emails. Attachments will not follow.

Look for a file with .SBB extension. If you want to restore it in 2003
again, you should be able to rename it .msbcm.

--
Mukesh Agarwal [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights
We upgraded 2 machines on our network from 2003 to 2007. I need to revert
back to 2003. The CEO is totally upset about this. We cannot use our BCM
right now. It said it made a backup of the bcm, which for the life of me
I
cannot find. I have backups of the mdf and ldf files. I called msft and
they told me to stop the mscontactmanagersmbiz service copy the files in
the
default directory and restart. Try to connect. However i have tried this
on
2 other machines and it does not work. I need to go backwards to 2003. I
dont have the compressed *.msbcm file or atleast I cannot see on the
drive.
Help!!!!!

Cheryl