So where is it? That is a great question that gets to the heart of an issue you need to change. Do you want the database to survive if the original creator leaves the company? YES! Did you know that won’t happen by default? Well if that user’s profile is deleted so goes the database. Gotcha!
We are talking about a server located and shared Business Contact Manager (BCM)/Small Business Accounting (SBA) database created using the fantastically easy Business Contact Manager for Outlook 2007 Database Tool.
Yes, location is everything as it applies to real estate, locating a city in hurricane-alley ocean-front and below sea level, and in BCM, Business Contact Manager this is also true. Let me explain that BCM was first designed to be run simply from a user(s) on a single desktop. Later SBA, Small Business Accounting, came along and was integrated with this same database for obvious great common data access. This design legacy still has an affect even as we can now move the BCM latest version’s database (.mdf & .ldf files) to the server for sharing, centralized management, and improved resources. It’s installed default location is at:
C:\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Business Contact Manager
So for database continuity and protection it is moving time unlike those inured and unresponsive to New Orleans’ death trap locale. Let’s put it in the same logical area as all other SQL databases under
“C:\Program Files\Microsoft SQL Server”
Since our database instance for BCM/SBA is MSSMLBIZ we will create a sub-folder there called “MSSQL$MSSMLBIZ” (imitating the other SQL folders). Now continue the following steps as follows:
- in Microsoft SQL Server Management Studio Express (SQL 2005 Express Advanced) under Object Explorer expand the database MSSMLBIZ, right click the target database which is by default “MSSmallBusiness”, and then “Detach” under Tasks
- now detached we go to the current file location of the .ldf & .mdf files (see above path) and “cut” them to start the move – note I only need the .ldf & .mdf files
- now we navigate to our newly created folder and “paste” them
- last step is to go back into the Studio and in the same place we did the “detach” we choose to “attach”, browse to our new location, and pick the .mdf file.
- Voila! It should complete and your now ready to open up an Outlook w/ BCM client and check that you are connecting. It’s all good now.
Later I’ll link to information on how to restore with just the .ldf & .mdf files if that was all you had since you were a bonehead and never did the BCM backup that Outlook Tasks reminds you of once a month. Perhaps you can figure out that desired goal sufficiently with the Studio knowledge learned solely from this post and working knowledge of NTBackup or whatever else you are using.
BCM Mastery Series
- Location, Location, Location
- BCM for Outlook 2007 Database Tool overview (being written)
- BCM for Outlook 2007 Database Tool Logging
- SQL Management Studio for the BCM Database (being written)
- SQL 2005 Express Advanced installation Walk Through (being written)