restore database from mdf / ldf files Cheryl 3/23/2007 6:05:03 AM 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

Re: restore database from mdf / ldf files "Mukesh Agarwal [MSFT]" <mukeshag[ at ]online.microsoft.com> 3/23/2007 5:57:22 PM 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[ at ]discussions.microsoft.com> wrote in message news:E85605C1-DF03-4EAB-88BE-2A973137B13B[ at ]microsoft.com... [Quoted Text] > 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

Re: restore database from mdf / ldf files Cheryl 3/28/2007 2:07:06 AM 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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > news:E85605C1-DF03-4EAB-88BE-2A973137B13B[ at ]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 > >

Re: restore database from mdf / ldf files Clinton Ford [MSFT] 6/13/2007 10:27:01 PM 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 [ at ]dbname = 'MSSmallBusiness', [ at ]filename1 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', [ at ]filename2 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\ MSSmallBusiness.ldf';" Windows XP ----------- OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db [ at ]dbname = 'MSSmallBusiness', [ at ]filename1 = 'C:\Documents and Settings\<USER>\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', [ at ]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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > > news:E85605C1-DF03-4EAB-88BE-2A973137B13B[ at ]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 > > > >

Re: restore database from mdf / ldf files Cheryl 6/13/2007 10:33:00 PM 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[ at ]hotmail.com "Clinton Ford [MSFT]" wrote: [Quoted Text] > 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 [ at ]dbname = 'MSSmallBusiness', > [ at ]filename1 = 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact > Manager\MSSmallBusiness.mdf', [ at ]filename2 = > 'C:\Users\<USER>\AppData\local\Microsoft\Business Contact Manager\ > MSSmallBusiness.ldf';" > > Windows XP > ----------- > OSQL -S .\MSSMLBIZ -E -Q "EXEC sp_attach_db [ at ]dbname = 'MSSmallBusiness', > [ at ]filename1 = 'C:\Documents and Settings\<USER>\Local Settings\Application > Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf', [ at ]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[ at ]discussions.microsoft.com> wrote in message > > > news:E85605C1-DF03-4EAB-88BE-2A973137B13B[ at ]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 > > > > > >