restore database from mdf / ldf files

Cheryl · External Since: Dec 15, 2004 Posts: 142

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] · External Since: Jan 18, 2007 Posts: 162

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
"Cheryl" <Cheryl DeleteThis @discussions.microsoft.com> wrote in message
news:E85605C1-DF03-4EAB-88BE-2A973137B13B@microsoft.com...
> 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 · External Since: Dec 15, 2004 Posts: 142

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.

"Mukesh Agarwal [MSFT]" wrote:

> 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
> "Cheryl" <Cheryl.DeleteThis@discussions.microsoft.com> wrote in message
> news:E85605C1-DF03-4EAB-88BE-2A973137B13B@microsoft.com...
> > 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] · External Since: Jan 24, 2007 Posts: 28

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

"Cheryl" wrote:

> 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.
>
> "Mukesh Agarwal [MSFT]" wrote:
>
> > 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
> > "Cheryl" <Cheryl.RemoveThis@discussions.microsoft.com> wrote in message
> > news:E85605C1-DF03-4EAB-88BE-2A973137B13B@microsoft.com...
> > > 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 · External Since: Dec 15, 2004 Posts: 142

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 theico4.RemoveThis@hotmail.com
"Clinton Ford [MSFT]" wrote:

> 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
>
>
> "Cheryl" wrote:
>
> > 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.
> >
> > "Mukesh Agarwal [MSFT]" wrote:
> >
> > > 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
> > > "Cheryl" <Cheryl.RemoveThis@discussions.microsoft.com> wrote in message
> > > news:E85605C1-DF03-4EAB-88BE-2A973137B13B@microsoft.com...
> > > > 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
> > >
> > >