How to attach database files to sql
From the command line:
OSQL -E -S .\mssmlbiz -d master -Q"CREATE DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and Settings\luther\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf') FOR ATTACH"
You will need to adjust the server\instance name to your instance; e.g. the default name with BCM v2 is microsoftsmlbiz.
posted by Luther Blissett at 8:54 AM
2 Comments:
If OSQL is not installed on your machine, try using sqlcmd. The parameters should be the same.
With BCM v3 (2007) the instance name is MSSMLBIZ.
Friday, April 11, 2008 10:12:00 AM
does anyone have "instructions for dummy´s" on how to do this?
I am trying to restore my system from a backup but my BCM database is not being recognised by BCM
Saturday, March 28, 2009 5:11:00 PM
Post a Comment
<< Home