June 11, 2002 at 9:24 am
what's the best way to move a SQL Server 7.0 database to another server.
June 11, 2002 at 1:51 pm
Detach, copy to new server, attach, then reconcile the logins - you may have to add some that don't exist on the new server, or fix broken links using sp_change_users_login.
Andy
June 11, 2002 at 3:09 pm
Or if use BACKUP DATABASE and backup to a file or tape and restore to the other server, same issues may arise.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 9:54 pm
How about if you stop all the SQL server services in both machines then copy all the data (MsSql\data) including master and msdb to the new server. Then restart the services. Assuming the new server doesn't have existing user databases. With these step you don't have to recreate users and jobs, etc.
June 20, 2002 at 4:37 am
That will work as long as you put the data files in the same physical location, not always possible..say if server A has the data on E and server B only has one drive.
Andy
June 20, 2002 at 5:36 am
Andy is right and you may have to correct the problem with the server name change if you are copying the master over. Several threads on that here.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 20, 2002 at 9:24 am
All in all, I recommend backup and restore. Others may differ, but in the last ten years, it's been the easiest and more reliable.
Steve Jones
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply