What I like you to do is to creaet backup job without using maintenance wizard to see whether it hangs or not. If it works fine, keep it running as...

Have you tried create backup job statement and schedule it to run? When you see job hang, go to server task manager to see how many sqlmaint.exe are there, Kill...

Right click LOG folder --> Properties --> Security Tab --> Tell us the accounts and permissions accouts have.

USE master

declare @dttm varchar(55)

select @dttm=convert(varchar,getdate(),113)

raiserror('Beginning InstPubs.SQL at %s ....',1,1,@dttm) with nowait

GO

if not exists (select * from sysdatabases where name='pubs')

begin

raiserror('Creating pubs database....',0,1)

CREATE DATABASE pubs...

Don't think you can do it with alter table command. You can use EM to insert new column at any position.

If you really want to place new column in...

Is your SQL Server service account in the local administrator group?

Definitely it takes less time than reboot. In my SQL Server clusters, it takes about 30 seconds depending on how many resources SQL server resource depend on.

I would check the SQL Server service account to see whether it has sufficient right to the directory the log files reside.

I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.

You can use Cluster administrator to fail-over from one node to another node, reboot the first node, fail-over to first node and reboot second node.

Depending on which patch you are...

What is your MDAC version and SQL Server service pack version?

Unfortunately you can see only SPID and last statement with dbcc inputbuffer you own if you are not 'sysadmin'.

Have you tried to install debugger from SQL Server CD?

You actually call dbcc inputbuffer command to see the last TSQL command.

DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other...

From BOL. You may already read it.

"Removing a Node from an Existing Failover Cluster

You can remove a node from a virtual server (for example, if a node is damaged). Each...