Re: MOVING SQL 2000 to a different computer, and domain

These should help:


http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's 2000
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://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
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=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000

http://www.sqlservercentral.com/scripts/contributions/1598.asp Script
Roles and Permissions

--
Andrew J. Kelly SQL MVP

"Vincent" <vfrissora@xxxxxxxxxxxxxxxxx> wrote in message
news:1180725914.645346.155430@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi, we have a sql 2000 server on an NT 4.0 box and would like to move
this to a newer Windows 2000 server in a different domain while
keeping all of the jobs, stored procedures and such. I have seen some
articles on how to do a SQL move, but I cannot find one specific to my
situation. I'm a little scared to follow some of the articles I've
seen because they usually involve moving sql within the same version
of windows or within the same domain.

I would also like to make this as transparent as possible to
computers and queries that connect to this server, which seems like it
would involve renaming our new SQL server name to our old SQL Server
name.

Can anyone point me to any articles or give me some sort of roadmap
that might address my specific needs? Thanks a lot. -Vincent.



.

Relevant Pages

  • Re: Migration ?
    ... During a restore, all of the metadata is upgraded. ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Copy Database Wizard
    ... Here is an article that list common "Copy DB Wizard" errors. ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... Restore ... for SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: deploying a database
    ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... Restore ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Backup Users
    ... Moving DB's between ... Moving SQL Server ... > a Restore ... > "Michael Tissington" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • RE: new install
    ... 264474 - System Database Backups Cannot be Restored on Diff. ... 304692 - Moving SQL Server DBs to a New Location w/ BACKUP & RESTORE ... I am positive that the above articles would help you with your issue. ...
    (microsoft.public.sqlserver.setup)