Re: migrate SQL 7 to 2000
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 12/06/04
- Next message: Keith Kratochvil: "Re: Slow initial record write"
- Previous message: Justin Rich: "Re: SQL 7.0 T-SQL Backup - Simple"
- In reply to: sec: "migrate SQL 7 to 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 12:21:36 -0600
You can move your data via BACKUP and RESTORE or sp_detach_db and
sp_attach_db.
You will also want to create users, jobs, and such on the new server.
Here are some links that you may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
-- Keith "sec" <sec@123.com> wrote in message news:%23xhnif42EHA.3908@TK2MSFTNGP12.phx.gbl... > i will buy a new server and migrate exiting SQL 7 to SQL 2000. How can i > migrate upgrade path > >
- Next message: Keith Kratochvil: "Re: Slow initial record write"
- Previous message: Justin Rich: "Re: SQL 7.0 T-SQL Backup - Simple"
- In reply to: sec: "migrate SQL 7 to 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
