April 12, 2002 at 10:09 am
I`ve been comissioned to move an SQL Server 6.5 database from one server to another (SQL Server 6.5 too). Whats the best and safest way to go about this?
Andy.
April 12, 2002 at 10:13 am
Backup and restore. This will not move logins, but you can move these by extracting them from master..syslogins and adding them to the new server.
A better idea is to install SQL 2000 (if oyu can) on a new server and upgrade the v6.5 server. You can run 2000 in v6.5 compatibility and not worry about keywords, etc.
Steve Jones
April 12, 2002 at 10:16 am
Thx for the input, I`ll try it this way first. I`d like to upgrade but the Server is the backend database of an old system that can`t be upgraded!!
Cheers,
Andy.
April 12, 2002 at 11:10 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply