Errata for Microsoft® SQL Server® 2008 MDX Step by Step
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| PDF |
Page \Mdx Step-by-Step.abf' specified in Restore command is damaged or is not an AS backup file.
Section "Restore the Analysis Services Database" |
An attempt to install the SSAS database for the book using the given command:
<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>C:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf</File>
<DatabaseName>MDX Step-by-Step</DatabaseName>
<Security>IgnoreSecurity</Security>
</Restore>
results in the following error:
The following system error occurred: Access is denied.
Backup and restore errors: File 'C:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf' specified in Restore command is damaged or is not an AS backup file.
Execution complete
|
Mark Zudeck |
Sep 16, 2011 |
| Printed |
Page Introduction
Pretty much the entire introduction |
After four days trying to install the example so I could begin to appreciate the contents of this book:
Using Windows 7 N Ultimate <X64> Build 7601: Service Pack 1, Microsoft SQL Server 2008 R2 (SP1) - Developer Edition (64-bit) , AND after performing all the steps on I believe all the posted eratta's, AND after giving just about all the Log On permissions to my personal Administrative account to just about everything which has SQL Server in the name in Services..... :: deep breath ::
I opened a New Query panel and executed the following file:
C:\Microsoft Press\MDX SBS\Setup\Analysis Services\restore_db.xmla
I can finally see what is printed on page 20, Step 2.
Beyond that, I have not yet determined what examples work in the book or how to back out of exposing my SQL Server to any flea to my entire SQL Server installation.
I am sure I am so exposed, a flea in another county could take Full Control of my entire system.
I can't believe after four days of work and two plus years in publish, these instructions don't work like a champ.
|
Anonymous |
Sep 30, 2011 |
| Printed |
Page xviii
The circled block of text before "Installing the Samples" |
The Sample download on page xviii doesn't appear to be version neutral. Using SQL Server 2008 R2 Standard edition i had error's deploying because feature's weren't present/available (Measure Expressions).
Later, on page 4, it is mentioned that the sample data is based on MS's Adventure Works sample data here: http://msftdbprodsamples.codeplex.com/
Though the A.W. sample data doesn't match the book provided sample exactly, it works equally well and is the only way to follow along with the book if you are running Standard.
|
Sean |
Apr 05, 2012 |
| Printed |
Page xx
Restore the Analysis Services database |
When executing the restore_db.xmla file's contents I get the following:
Executing the query ...
The following system error occurred: Invalid procedure call or argument
Backup and restore errors: File 'C:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf' specified in Restore command is damaged or is not an AS backup file.
Execution complete
|
Anonymous |
Jun 19, 2013 |
| Printed, PDF, ePub, Mobi, , Other Digital Version |
Page 1
Installation Issue |
When attempting to install the Analysis Services database, we get the following error using the restore_db file:
Executing the query ...
The following system error occurred: Access is denied. .
Backup and restore errors: File 'C:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf' specified in Restore command is damaged or is not an AS backup file.
Execution complete
Resolution:
To resolve this issue, you can simply open the solution file with BIDS, then process the database. Assuming you are using BIDS on the same computer where SQL Server is installed, the SSAS database will install automatically while it is processing. Takes all the hassle out of the installation.
|
Jim Davis |
Mar 22, 2013 |