By database reduce job do mean that you are shrinking the DB?

here follow this

----http://msdn.microsoft.com/en-us/library/dd266793%28VS.90%29.aspx

Open Services Manager and start SQL Server FullText Search. If Full Text Search is not installed, install it. Then retry the installation.

1.

Click Start,...

FTS is a goggle type of search engine that runs within sql server started in 2008, sounds like the TFS server is looking for it.

you will need to go back...

hopefully you have a log shipping or database mirroring up to date in case something goes wrong. you never know when what will happen when you fail over.

I would fail...

This question has been asked many times! There are lots of threads on this web site that cover this.

In a Nut shell, training is helpful but to be a good...

..biggest thing to think about is this

. the principal writes a transaction sends it to the mirror the the mirror must commit tell the principal that success has occurred then...

here is a good way... I didn't create the proc...but you can make the needed changes to it....like change the grant exec to grant alter.....

if you are using window auth...

I agree with Paul if you are just looking at (user, security, backup/restore) then not much has changed...

if you are looking at performance tunning, sql reports or ssis ...

I agree the Mirror is probably the easiest to set up. as long as you set up the mirror in high-safety mode you will not loose any data....just be careful...

I agree on the interview question!

the first one can be done a number of ways, DMV, profiler, server side trace, performance dashboard(which uses DMV) 2005 , Data collection 2008.

the...

I am in the process of doing the same, please advise if you find anything else.

I have not as of yet

THANKS

here they say you need a premium account but look at the sec link ...looks like this person found a work around

http://www.sqlservercentral.com/Forums/Topic583905-145-1.aspx#bm585971

http://blogs.msdn.com/b/billramo/archive/2009/03/29/using-live-hotmail-msn-for-sql-server-2008-database-mail.aspx

I am sure everyone has a diif method but we release ours to svn folder where we group everything by project, then if you have some fixes between large release...

If you try to do the install it will fail.

check here....http://msdn.microsoft.com/en-us/library/ms143506.aspx#SEx64

On the step , go to advanced tab and set "On set on failure action" to go to next step

On notification set when the job fails......

that should work