Mitdasein in the experience of encountering the customer in our common having been cast into the opening of beyng

Friday, July 17, 2009

How to restore a database the hard way

This is for when the regular backup through BCM doesn't work. Be sure to change domain, user, database, and paths to your circumstances.

You have a backup file c:\temp\foobar.sbb of your database MSSmallBusiness.

Rename the file to foobar.zip.

In Explorer double-click on it to go into (like a folder). Inside you will find an xml file and a file named like en-US#3.0.5625.0. Copy the second file to c:\temp\en-US#3.0.5625.0.

Open a cmd window (On Vista+ as administrator).

Use sqlcmd to connect to the master database: sqlcmd -E -S .\mssmlbiz -d master

Run this command to restore the database:
RESTORE DATABASE MSSmallBusiness  FROM disk = 'C:\temp\en-US#3.0.5625.0'
with replace,
move 'MSSmallBusiness_dat' to 'c:\users\luther\AppData\Local\Microsoft\Business Contact Manager\MSSmallBusiness.mdf',
move 'MSSmallBusiness_log' to 'c:\users\luther\AppData\Local\Microsoft\Business Contact Manager\MSSmallBusiness.ldf'
GO
EXIT

If you've moved to another machine (e.g. you are restoring because the machine you created the backup on is no more), you will probably need to take ownership.

Connect to the database: sqlcmd -E -S .\mssmlbiz -d MSSmallBusiness

Then:
sp_changedbowner 'wuming\luther'
GO
EXIT

Now you can restart Outlook/BCM. If you were not using database MSSmallBusiness before, you will need to select that database. If you run into errors, try restarting Outlook.

If you run into trouble with the SQL, here are the docs for RESTORE.

4 Comments:

Anonymous Anonymous said...

I used to be recommended this website by my cousin.
I am now not sure whether this put up is written by way of him as no
one else know such detailed about my problem.

You are wonderful! Thanks!
Also visit my web site free porn

Friday, December 14, 2012 9:14:00 AM

 
Anonymous Anonymous said...

Quality articles or reviews is the secret to interest the viewers to visit the web page, that's what this web page is providing.
Take a look at my site : teen porn

Friday, December 14, 2012 4:55:00 PM

 
Anonymous Anonymous said...

I enjoy what you guys tend to be up too. Such clever work and exposure!
Keep up the very good works guys I've added you guys to blogroll.
Here is my web site ... Hottest group Filipino sex ever!

Wednesday, December 19, 2012 10:41:00 AM

 
Anonymous Anonymous said...

I used to be able to find good info from your blog articles.



Also visit my weblog hotgirlsexcam.com

Sunday, June 02, 2013 8:59:00 AM

 

Post a Comment

<< Home