October 22, 2015 at 10:11 am
I bought this book quite a while ago and never got round to read it. Now I'm planning to take the 2012 exam (70-462) and am going through this book as well. It seems to have issues and there is no errata even after such a long time. Perhaps you have made your own errata? Please join me in creating a community produced errata for this book:
The real MCTS sql server 2008 exam 70-432,
Written by Mark Horninger, and others
Published by Syngress ISBN 9781597494205
1. Page 29: Correct answer to 9 is B (not A)
2. Page 73: The alter statement is incorrect. You can either write it in one create database statement like this:
create database research on primary
(name = researchprimary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.mdf',
size=10mb, maxsize=700, filegrowth=20),
filegroup secondary
(name = researchsecondary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.ndf',
size=10mb, maxsize=700, filegrowth=20);
or with an combined create and alter database statement like this:
create database research on primary
(name = researchprimary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.mdf',
size=10mb, maxsize=700, filegrowth=20);
alter database research add filegroup research1;
alter database research add file
(name = researchsecondary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.ndf',
size=10mb, maxsize=700, filegrowth=20) to filegroup research1;
3. page 90. To connect to the second instance you need to connect to <YourComputerName>\SQL2
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply