Thursday, March 8, 2012

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 connectin
g
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 droptable.com
http://www.droptable.com/Uwe/Forum...server/200508/1Good stuff
http://vyaskn.tripod.com/moving_sql_server.htm
"Nick via droptable.com" <forum@.droptable.com> wrote in message
news:534E920C33D81@.droptable.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 droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1

No comments:

Post a Comment