Unable to Restore Data File in Small Bus Acct. 2006 SP3 - ElMagit
By John Everett
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.
Popularity (124 Views)
Article Discussion: Unable to Restore Data File in Small Bus Acct. 2006 SP3 - ElMagit