blocking all connections for final cut over to new SQL server machine

Hi ALL,
I'm replaceing the old SQL server machine to the new & better SQL server
machine. i already done all the moves but in the final cut over planning, i
need some help. How can i restrict all users and applications from connecting
to the old machine. so that in the down time i can take the Final
Transactional log backup and restore to the new SQL server machine. i know i
can use Single user move or Change IP address to the old machine or i can
denay all users access. BUT i don't know which one is better way to do and
why?
are there any other way of doing this?
Any feedback will be greatly appreciated.
THANKS
Nick
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1Good stuff
http://vyaskn.tripod.com/moving_sql_server.htm
"Nick via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:534E920C33D81@.SQLMonster.com...
> Hi ALL,
> I'm replaceing the old SQL server machine to the new & better SQL server
> machine. i already done all the moves but in the final cut over planning,
> i
> need some help. How can i restrict all users and applications from
> connecting
> to the old machine. so that in the down time i can take the Final
> Transactional log backup and restore to the new SQL server machine. i know
> i
> can use Single user move or Change IP address to the old machine or i can
> denay all users access. BUT i don't know which one is better way to do and
> why?
> are there any other way of doing this?
> Any feedback will be greatly appreciated.
> THANKS
> Nick
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1