search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsFAQs
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Operating SystemsArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

Unable to Restore Data File in Small Bus Acct. 2006 SP3 - ElMagit


By John Everett
Printer Friendly Version
View My Articles
1 Views
    

The easiest way to restore a MSOA file is to have the two data files from the C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data directory. The .X could be any number. The information is available from MSKB Article 919451 Basically the backup is good only if you have the original installation running on the original machine. Once you change machines (not including Multi-User) the .SBD and .SBL files are necessary for an easy recovery.

El Magito,the easiest way to restore a MSOA file is to have the two data files from the C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data directory.
The .X could be any number. The information is available from MSKB Article 919451 Basically the backup is good only if you have the original installation running on the original machine. Once you change machines (not including Multi-User) the .SBD and .SBL files are necessary for an easy recovery.


button
Article Discussion: Unable to Restore Data File in Small Bus Acct. 2006 SP3 - ElMagit
John Everett posted at Tuesday, March 18, 2008 5:32 AM
Original Article