This article will help in transferring the logins from one machine to the
You will want to BACKUP and RESTORE your databases from one server to the
other. The other option would be sp_detach_db and sp_attach_db. Both
methods are documented within Books Online.
Unless you modify the stored procedures listed in the support article to
also include the SID, you will probably need to use the stored procedure
sp_change_users_login within each user database after you restore to the
As I mentioned, you will want to backup your user database(s), msdb (if you
have any jobs defined) and model (if you made any changes to the model db on
your existing server).
One final thing: make sure that you install SQL Server with the same char
set / sort order as you have on your current box.
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> Can anyone provide or direct me to advice regarding the best way to
> move an entire SQL Server 7 installation from an existing box to a new
> server? The current OS is NT 4.0; the new OS will be W2K Advanced
> I'm not sure how best to move the system databases and what order to
> do things in. Can all databases (system dbs also) simply be backed up
> and restored? If so, should the system databases come first? Are
> there better ways?
> Tips, comments, pitfalls, or advice of any kind would be most
> appreciated. Thank you!