Microsoft Knowledge Base Email Alertz

KBAlertz.com: How to restore a company database file after you upgrade from Windows XP to Windows Vista if a backup file was not created in Accounting Express 2007, in Accounting Professional 2007, or in Small Business Accounting 2006

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **


Bug Tracking Software
For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.


Community Site



We Send hundreds of thousands of emails using ASP.NET Email



Expert Web Design & Graphic Design
Design44.com

ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 942006 - Last Review: September 10, 2007 - Revision: 1.0

How to restore a company database file after you upgrade from Windows XP to Windows Vista if a backup file was not created in Accounting Express 2007, in Accounting Professional 2007, or in Small Business Accounting 2006

INTRODUCTION

This article describes how to restore a company database file after you upgrade from Windows XP to Windows Vista if a backup file was not created in Microsoft Office Accounting Express 2007, in Microsoft Office Accounting Professional 2007, or in Microsoft Office Small Business Accounting 2006.

MORE INFORMATION

After you upgrade from Windows XP to Windows Vista, you may discover that a backup file was not created in Accounting Express 2007, in Accounting Professional 2007, or in Small Business Accounting 2006. To restore a company database file in this situation, follow these steps.

Note You must have administrator access to attach or to detach a company database file.
  1. Install one of the following programs on the computer that you upgraded from Windows XP to Windows Vista:
    • Accounting Express 2007
    • Accounting Professional 2007
  2. Copy the .sbd file and the .sbl file from the backup folder that was created when you installed Windows Vista. The backup folder is in the following location:
    • In Small Business Accounting 2006, the following path is the path of the backup folder:
      C:\Windows.old\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data
    • In Accounting Express 2007 or in Accounting Professional 2007, the following path is the path of the backup folder:
      C:\Windows.old\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Data
      Note The MSSQL.x placeholder represents the folder for an instance of SQL Server on the computer. If more than one instance is installed, replace the placeholder with the correct folder for the instance of SQL Server that is running.
  3. Save the .sbd file and the .sbl file in the following folder:
    C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data
  4. Attach the company database files that you saved in step 3, and then create a new .sbc file. To do this, follow these steps:
    1. Use the appropriate method:
      • In Accounting Express 2007 or in Accounting Professional 2007, click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Accounting 2007 Tools, and then click Data Tools.
      • In Small Business Accounting 2006, click Start, point to All Programs, point to Microsoft Small Business Accounting, and then click Data Tools
    2. In the Microsoft Office Accounting Data Utilities dialog box, click the Advanced Tools tab.
    3. Click Attach.
    4. In the Attach a Database dialog box, click Browse, locate the company database file that you want to attach, and then click Open.
      Notes
      • By default, the data file is located in the following directory:
        C:\Program files\Microsoft SQL Server\MSSQL.x\MSSQL\Data
      • The company database file is an .sbd file.
    5. In the Database name field, type the name for the new company database. This will be the name of the company database (.sbc) file.
    6. Click Attach.
    7. Click OK.
    8. Click Close to close the Microsoft Office Accounting Data Utilities dialog box.

REFERENCES

For more information about how to move company databases, click the following article number to view the article in the Microsoft Knowledge Base:
919451  (http://kbalertz.com/Feedback.aspx?kbNumber= 919451/ ) How to move a company database file from one computer to another computer in Accounting Professional 2007, in Accounting Express 2007, or in Small Business Accounting 2006

APPLIES TO
  • Microsoft Office Accounting Express 2007
  • Microsoft Office Accounting Professional 2007
  • Microsoft Office Small Business Accounting 2006
Keywords: 
kbhowto kbmbsmigrate kbexpertiseinter kbexpertisebeginner KB942006
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Be the first to leave feedback, to help others about this knowledge base article.

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please