Viewing 15 posts - 421 through 435 (of 972 total)
Patrick2525 (2/16/2011)
February 16, 2011 at 3:58 pm
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...
February 16, 2011 at 3:54 pm
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...
February 16, 2011 at 3:53 pm
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)...
February 15, 2011 at 11:19 am
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,...
February 13, 2011 at 2:40 am
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...
February 13, 2011 at 12:06 am
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...
February 12, 2011 at 11:57 pm
I need to restore sql 2000 master db on sql server 2005.
can this happen?
No. You cannot restore system databases from one edition of SQL Server to another.
EDIT: Well you might...
February 12, 2011 at 11:53 pm
error in posting...must of hit quote again instead of edit.
February 12, 2011 at 11:52 pm
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...
February 11, 2011 at 6:36 pm
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...
February 11, 2011 at 3:26 pm
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...
February 10, 2011 at 6:38 am
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...
February 9, 2011 at 11:38 am
DBCC PAGE command should help you out.
February 6, 2011 at 11:59 pm
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...
February 6, 2011 at 11:43 pm
Viewing 15 posts - 421 through 435 (of 972 total)