rename sql

I need to rename a brand-new build of a Win2003/SQL2k box. I know with
SQL2k that renaming is essentially a snap, and I know how to do it. But my
question is this: should I rename it, or should I; uninstall sql, rename the
box and then reinstall sql? I don't want to have any potential issues in
the future, and I have the time to reinstall if that's the best solution.
Thanks, AndreHi, Andre
See: http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
Razvan|||Renaming a server is fine. See http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre" <no@.spam.com> wrote in message news:%23ZvSVmmbGHA.628@.TK2MSFTNGP04.phx.gbl...
>I need to rename a brand-new build of a Win2003/SQL2k box. I know with
> SQL2k that renaming is essentially a snap, and I know how to do it. But my
> question is this: should I rename it, or should I; uninstall sql, rename the
> box and then reinstall sql? I don't want to have any potential issues in
> the future, and I have the time to reinstall if that's the best solution.
> Thanks, Andre
>|||Thank you.

rename sql

I need to rename a brand-new build of a Win2003/SQL2k box. I know with
SQL2k that renaming is essentially a snap, and I know how to do it. But my
question is this: should I rename it, or should I; uninstall sql, rename the
box and then reinstall sql? I don't want to have any potential issues in
the future, and I have the time to reinstall if that's the best solution.
Thanks, AndreHi, Andre
See: http://support.microsoft.com/defaul...kb;en-us;303774
Razvan|||Renaming a server is fine. See http://www.karaszi.com/SQLServer/in...r />
_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andre" <no@.spam.com> wrote in message news:%23ZvSVmmbGHA.628@.TK2MSFTNGP04.phx.gbl...seagreen">
>I need to rename a brand-new build of a Win2003/SQL2k box. I know with
> SQL2k that renaming is essentially a snap, and I know how to do it. But m
y
> question is this: should I rename it, or should I; uninstall sql, rename t
he
> box and then reinstall sql? I don't want to have any potential issues in
> the future, and I have the time to reinstall if that's the best solution.
> Thanks, Andre
>|||Thank you.sql

removing alternate snapshot location setting

I was using an "alternate snapshot
location" for the storage of my reinitilized
snapshot data. All those snap shots have
made it to the subscribers. I am now
wanting to go back to those pacakges and set
their snapshot location back to default
(basically the default dir on the
distributor). When I go back and check that
check box, it's not going to try to start a
new snapshot is it?
I figured once the snapshot was done and
pushed over, that the rest of replication
would be the sync'ing part.
Thanks,
-comb
No - this doesn't cause the snapshot agent to start automatically, or mark
the subscribers for reinitialization.
It only affects things the next time you choose to run the snapshot agent.
Regards,
Paul Ibison
|||In article <OPxX59qfEHA.556
@.tk2msftngp13.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> No - this doesn't cause the snapshot agent to start automatically, or mark
> the subscribers for reinitialization.
> It only affects things the next time you choose to run the snapshot agent.
> Regards,
> Paul Ibison
>
>
that is perfect then.. thats the information
i needed to know..
thanks for the response..
-comb