[quoted text, click to view] > Will node2 first will rollback the transaction and only then the server will
> be available?
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
[quoted text, click to view] "Roy Goldhammer" 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@gmail.com> ???
> ??????:OjkeXTyGIHA.1184@TK2MSFTNGP04.phx.gbl...
> > 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@hotmail.com> wrote in message
> > news:eOtR8AyGIHA.4592@TK2MSFTNGP02.phx.gbl...
> >> 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?
> >>
> >
>
>
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@gmail.com> ???
??????:OjkeXTyGIHA.1184@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view] > 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@hotmail.com> wrote in message
> news:eOtR8AyGIHA.4592@TK2MSFTNGP02.phx.gbl...
>> 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?
>>
>
