moving to a new server

I need to move my Production SQL box to a new box, in a new domain, with a
new name for the box itself. Can someone point me to a white paper for this?
I've done alot of stuff similar to this, but theres enough differences here
make me nervous.
--
SQL2K SP3
TIA, ChrisRWhat all do you need to move? User databases are easy. Are you just moving
the box an upgrading it or are you moving the entire installation? Is this
a stand-alone server or a SQL Server Fail Over cluster?
Sincerely,
Anthony Thomas
"ChrisR" <bla@.noemail.com> wrote in message
news:OSZNAbW4EHA.1188@.tk2msftngp13.phx.gbl...
I need to move my Production SQL box to a new box, in a new domain, with a
new name for the box itself. Can someone point me to a white paper for this?
I've done alot of stuff similar to this, but theres enough differences here
make me nervous.
--
SQL2K SP3
TIA, ChrisR|||Everything is being moved. All system and User db's. I've done all of it in
the past but not to a new domain, new box name, etc. No its not clustered.
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uEXcRAY4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> What all do you need to move? User databases are easy. Are you just
moving
> the box an upgrading it or are you moving the entire installation? Is
this
> a stand-alone server or a SQL Server Fail Over cluster?
> Sincerely,
> Anthony Thomas
>
> --
> "ChrisR" <bla@.noemail.com> wrote in message
> news:OSZNAbW4EHA.1188@.tk2msftngp13.phx.gbl...
> I need to move my Production SQL box to a new box, in a new domain, with a
> new name for the box itself. Can someone point me to a white paper for
this?
> I've done alot of stuff similar to this, but theres enough differences
here
> make me nervous.
> --
> SQL2K SP3
> TIA, ChrisR
>|||Moving user databases is easy, just detach and reattach. For the system
databases, make sure the new install is running the same version, edition,
and service pack and hotfix patch levels. At that point, you can just
replace the system databases with copies of the old.
To handle the new domain/computer name, SQL Server will automatically assume
the name of the server it is running on. If this is a named instance, this
can be a little trickier. Nevertheless, for linked servers and replication,
the master database also knows what server it is running on. You will have
to change that after you have moved master to the new host.
sp_dropserver <old_name>
sp_addserver <new_name>, local
Sincerely,
Anthony Thomas
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%238s9JPY4EHA.1404@.TK2MSFTNGP11.phx.gbl...
Everything is being moved. All system and User db's. I've done all of it in
the past but not to a new domain, new box name, etc. No its not clustered.
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uEXcRAY4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> What all do you need to move? User databases are easy. Are you just
moving
> the box an upgrading it or are you moving the entire installation? Is
this
> a stand-alone server or a SQL Server Fail Over cluster?
> Sincerely,
> Anthony Thomas
>
> --
> "ChrisR" <bla@.noemail.com> wrote in message
> news:OSZNAbW4EHA.1188@.tk2msftngp13.phx.gbl...
> I need to move my Production SQL box to a new box, in a new domain, with a
> new name for the box itself. Can someone point me to a white paper for
this?
> I've done alot of stuff similar to this, but theres enough differences
here
> make me nervous.
> --
> SQL2K SP3
> TIA, ChrisR
>|||I hope this will help as a reference (from Andrew J. Kelly):
http://www.support.microsoft.com/?id=314546 ; Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 ; Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 ; Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 ; How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 ; Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp ; Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 ; User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 ; How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 ; Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 ; Copy DB Wizard issues
Sasan Saidi
MSc. CS, MCSE 4, Certified IBM MQ Administrator
Senior DBA
Brascan Business Services
"ChrisR" wrote:
> I need to move my Production SQL box to a new box, in a new domain, with a
> new name for the box itself. Can someone point me to a white paper for this?
> I've done alot of stuff similar to this, but theres enough differences here
> make me nervous.
> --
> SQL2K SP3
> TIA, ChrisR
>
>|||Perfect! Thanks.
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:B400D908-0407-4925-BAD1-3493A1E6A8DB@.microsoft.com...
> I hope this will help as a reference (from Andrew J. Kelly):
> http://www.support.microsoft.com/?id=314546 ; Moving DB's between
Servers
> http://www.support.microsoft.com/?id=224071 ; Moving SQL Server
Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 ; Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 ; How To Transfer Logins
and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 ; Mapping Logins & SIDs
after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp ; Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 ; User Logon and/or
Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 ; How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 ; Disaster Recovery Articles
> for SQL Server
> http://www.support.microsoft.com/?id=274463 ; Copy DB Wizard
issues
> Sasan Saidi
> MSc. CS, MCSE 4, Certified IBM MQ Administrator
> Senior DBA
> Brascan Business Services
>
> "ChrisR" wrote:
> > I need to move my Production SQL box to a new box, in a new domain, with
a
> > new name for the box itself. Can someone point me to a white paper for
this?
> > I've done alot of stuff similar to this, but theres enough differences
here
> > make me nervous.
> >
> > --
> > SQL2K SP3
> >
> > TIA, ChrisR
> >
> >
> >