Re: How to move SQL 2000 server to new hardware



Thanks!
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:Ov3aJFjFGHA.4036@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>>
>>
>
>


.



Relevant Pages

  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Two Disaster Recovery Questions
    ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant restore master db!!
    ... I tried starting the server as you & Hari instructed; the server started in single user mode. ... the restore has to be issued from the Veritas software interface. ... SQL Server returned the following error message: ...
    (microsoft.public.sqlserver.server)
  • Re: Restore from backup very slow
    ... It has to have the same number of database files, ... Tibor Karaszi, SQL Server MVP ... > restore process is much faster. ...
    (microsoft.public.sqlserver.server)
  • Re: Restore database
    ... You can find details in BooksOnLIne under RESTORE. ... for SQL Server ... i need to restore a data base that was in one server to> another server. ...
    (microsoft.public.sqlserver.setup)