Restoring BCM database from .mdf and .ldf files AFTER Windows 7 Professional 64-bit custom install from Vista Ultimate 32-bit

  • Thread starter EcstaticWin7User
  • Start date Views 658
Status
Not open for further replies.
E

EcstaticWin7User

I did not know that I could not simply copy my Business Contact Manager 2007 files in Vista Ultimate (located in my AppData\Local\Microsoft\Business Contact Manager) to my external hard drive and then back to new user file same location after custom install of Windows 7 Professional 64-bit. Actually, I changed user name because I am standardizing user names on home network as it has grown into a 'real' network of users and equipment; small business users, family users, and visiting guests (usually family, but now sometimes business guests to accommodate.)

I have tried everything I can think of to restore my database including solutions I found via Bing and google searches: http://blogs.msdn.com/bcm/archive/2007/10/22/restoring-a-bcm-database-from-sql-mdf-and-ldf-files-windows-vista-or-xp.aspx, https://forums.slipstick.com/showthread.php?t=28860, and http://dbaspot.com/forums/sqlserver-faq/230596-attach-sql2005-database-different-directory.html.

None of these worked.

I really need the data in this database.

Any suggestions?
 
E

Ezil Vinoth



Try below mentioned steps to resolve the issue:

METHOD 1:

Give permission to .ldf and .mdf files and try to import because you have changed the user name.
To give permission:
Right click on .ldf file and click on properties.
Click on security tab and click on Add.
Type “everyone” without quotes in the “Enter the object name to select” and click on Ok.
Check the box below ALLOW, click on Apply and Ok .

FOLLOW THE SAME STEPS FOR .mdf file and then try to import.

METHOD 2:
Create a new data base and replace the .ldf and .mdf files.
When new database is created, we will get a .ldf and .mdf file and these will have a name.
Replace the old .ldf and .mdf file with the names that are for the new database.
STOP the SQL Server which is running by going to services.msc
Replace the .oldg and .mdf files
Start the SQL Server and check.

Check with these links for more information:
http://office.microsoft.com/en-us/outlook/HP011134941033.aspx

Ezil Vinoth S, Microsoft Answers Support Engineer.

• We appreciate your participation in MS Forums, Help us understand your needs better. To share your valuable Feedback please Click here.

 
Status
Not open for further replies.
Top