July 12, 2011 at 7:22 am
Hi All
A previous post of mine was in relation to prep for the certifications, to which I went and purchased the MCTS 70-432 self paced training book.
Just flicking through the first chapters scanning for anything which is a bit foreign to myself and one thing that the book says is that only Enterprise supports multi instances. Now I thought both Standard and Enterprise support them, with 16 and 50 instances retrospectively per machine. I also believe that workgroup supports multi instances as well but as I am not familiar with this edition, I cannot comment.
Would appreciate any thoughts or comments.
Thanks
Ant
July 12, 2011 at 8:13 am
the MCTS press book does have some issues. It also states that Windows server standard may be used for clustering, when only enterprise or datacenter may be used for cluster nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2011 at 8:16 am
Thanks Perry, I knew the book was flaky when I bought it, but the instance issue hadn't cropped its head in any of the comments that I looked at about the book. Just threw me a little, just wanted to check for my own sanity.
July 12, 2011 at 8:52 am
i found a few issues and reported them to MS and they said they were known issues. I'm sure number of instances was one of them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2011 at 4:07 am
On the same subject but not instances this time but backups and restores
Just run through a practice exam and there is one question which I got wrong and I appreciate that, but the answer is contradicting itself.
Situation is
Production DB crashed at 10:43, bring back online with as little effort and is using merge replication
Backup routine
* A full backup nightly at 2 A.M.
* Differential backups every two hours
* Transaction log backups every two minutes
so you have restored it to 10:42 and merge replication has pushed in the last minute of data
Backed up the database as 1:20PM which is when it was back operational
At 11PM the whole system crashed and you need to recover everything
So I chose
Backup Tail Log
Restore 1:20PM Full backup
Restore 10PM Differential Backup
Restore TX logs from 10PM onwards
Restore Tail Log
But the answer is saying
Restore 1:20PM Full backup
Restore 10PM Differential Backup
Restore TX logs from 1:20PM onwards
Now this is wrong as you cannot restore 1:22PM TX log as the database is further forward then the log you are trying to restore.
The tail log is a miss read from myself as it does say that the whole disk system failed so you cant do a tail log so I accept that this part is wrong. But I am not accepting the correct answer anyway.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply