Patrick2525 (2/16/2011)

---

Yes, it's very frustrating trying to study for the exams when the study guides are wrought with errors and contradictions. I wish those things were peer reviewed. However, these...

Duncan Pryde (2/16/2011)

---

Although I haven't done that exam myself as I upgraded directly from 2005 to 2008 MCITP, most of the Admin exams I've done have contained a fair amount...

I call shenanigans. How can the answer not be no? If a database is set to Bulk-Logged recovery model that means some transactions are minimally logged. That would mean the...

If it is on the same server the database was encrypted on I don't believe you have to do anything.

You can read this article on SSC: Transparent Data Encryption (TDE)...

The simply answer is SQL Server will not allow you to. The master database holds all the system level information about the instance of SQL Server. Between major versions, hotfixes,...

Ignite is a good tool as well. Put out by Confio. Thomas LaRock has done a few live demos of it recently. I think he has one coming up in...

01. Our primary database size is about 4tb. We are not able to take the backup to tape as the tape size is 3.5tb. Is there anyway we can fire...

No. You cannot restore system databases from one edition of SQL Server to another.

EDIT: Well you might...

error in posting...must of hit quote again instead of edit.

So without violating the NDA, can someone tell me if I need to study all the the text commands, or will experience and practice doing these tasks thought the GUI...

I have that book but not have not been consistently reading it 😀 I do like the layout and how it reads so far.

I have taken 70-432 but did not...

Well you may not actually see any error in the SQL ERRORLOG file but default location is:

C:\Program Files\Microsoft SQL Server\MSSQ.1\MSSQL\LOG.

I would actually first look in your Windows Event Log (Start...

We can't tell you what is wrong unless you tell us what problem you are experiencing. What you are seeing is the state of each service of SQL Server. I'm...

DBCC PAGE command should help you out.

If I'm not mistaken when you have multiple instances of SQL Server on the same box it will use 1434. Then this is where SQL Server Browser service comes into...