It's always the last thing that is checked, at least I stop there anyway!

Assuming you used this proc from BOL, the filename needs to be modified to 'E:\SQLData\tempdb.mdf', same for log. Otherwise as dcpeterson described!

1. Determine the logical file names for the tempdb database....

If we are talking fantasy cars, I want a flying car. It is the 21st century, I was promised we would have one by then. So where is it!

For the...

We are using CommVault, seems to work relatively well.

http://www.commvault.com/

Append, it will work, they are numbered through 24 and restore without any difficulty. It may be a little annoying to go through each restore, just remember to return the...

I agree, a lot of software is rushed to production. Everyone trying to make a dollar or be the first to market. But Microsoft did not start it. Ever since...

We get 3000 USD a year, it would be nice if it were enough for a cert or upgrade a degree. If you are going to do training, do more...

There are several assumptions I am making relative to your setup. To answer your question: stopping SQL services from EM or the OS signals a failure to the cluster, which...

Not to be difficult, but I disagree that your plan will work "as is".

First, you should only stop and start sql services from the cluster not EM or the OS. Second,...

This is why I never try to answer these questions any more, most are ill-posed!

Not sure about Geo Cluster, but I have SQL 2k on a Win 2k3 cluster and installed SP4 without issues. There is a MS kb for installing on a cluster,...

Me too!! I got a 5GB Seagate pocket drive for Christmas. It has been a very helpful, really useful device, plenty of space and I can take it where ever.

Show me the money!

You are a bunch of newbies! I remember way back when databases were flat files on an Atari. Dbase, Rbase, CISAM, Access, DB2, Oracle, SQL Server, Clarion and several proprietory...

My suggestion is to bite the bullet and get one person trained, even if you pay for it yourself, then you have doubled your productivity! It is your responsibility as a...