Re: How to move SQL 2000 server to new hardware
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 17:00:32 -0500
See if these help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
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
"Arch Willingham" <nospam_arch@xxxxxxxxxxx> wrote in message
news:%230kV2miFGHA.516@xxxxxxxxxxxxxxxxxxxxxxx
> Our SQL2000 server computer is old. I need to replace system but will keep
> the computer name the same. How do I move the current SQL server
> configuration to new system?
>
> Thanks!
>
> Arch
>
>
.
- Follow-Ups:
- Re: How to move SQL 2000 server to new hardware
- From: Arch Willingham
- Re: How to move SQL 2000 server to new hardware
- References:
- How to move SQL 2000 server to new hardware
- From: Arch Willingham
- How to move SQL 2000 server to new hardware
- Prev by Date: How to move SQL 2000 server to new hardware
- Next by Date: Re: How to move SQL 2000 server to new hardware
- Previous by thread: How to move SQL 2000 server to new hardware
- Next by thread: Re: How to move SQL 2000 server to new hardware
- Index(es):
Relevant Pages
|
