Hello there

Here is question i got:
I have sql server 2005 failover clustering. On node1 someone has run
procedure which update data on huge table which take over 8 hours.

In this case I can't release the database (as far as i know) because if i
will kill the process it will rollback all the actions and it won't be
released. I can't even restart the service because the rollback will always
occur.

If on failover I stop the service on node1 and node2 comes to air will this
release the server?

No.

For this purpose, a failover is exactly the same as a service stop and
restart.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote

Whell Geoff
If i run huge trasaction which takes 50 minutes
and after 45 minutes node1 goes down.

Will node2 first will rollback the transaction and only then the server will
be available?

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> ???
??????:OjkeXTyGIHA.1184 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

The server will be available rather quickly (seconds). But the database in
question may take a while to become available. However, if you are using
SQL2005 enterprise edition, you should be able to access the database as soon
as it has finished rolling committed transactions forward and while it's
rolling uncommitted changes back. Of course, you won't be able to access the
data that is being touched by the undo transactions.

Linchi

"Roy Goldhammer" wrote: