Best way to move SQL 6.5 to new hardware

Hi,
Can anyone tell me the best way to moving MS SQL 6.5 System to new
Hardware Box?
I already setup new SQL Server using different computer name, just want
to copy all data and security info to new one.
Many thanks in advance.
Regards,
Chris Lee
Chris,
there's a huge amount of things to take into account, but when I did it I
found this article very helpful:
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
HTH,
Paul Ibison
|||Dear Paul,
Thanks for your reply, but the article apply to SQL 6.5 to SQL 6.5 upgarde?
Regards,
Chris Lee
|||Hi,
Did you installed the SQL Server with the same directory structure as actual
(Old) SQL server. If yes then:-
1. Apply the same service pack in the new server (Probably sp5a + post
update 5a)
2. Stop the SQL server in old server and new server
3. Copy all the DAT (Including system databases) files from (
drive:\mssql\data) old server to
new server
4. Start SQL server in new server
5. Using ISQLw login to SQL Server and execute the below script
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
6. Stop and Start the SQL Server service
Thanks
Hari
MCDBA
"Chris Lee" <c_h_r_i_s_l_e_e_@.h_o_t_m_a_i_l_._c_o_m> wrote in message
news:ca93g0$2pf8@.imsp212.netvigator.com...
> Hi,
> Can anyone tell me the best way to moving MS SQL 6.5 System to new
> Hardware Box?
> I already setup new SQL Server using different computer name, just want
> to copy all data and security info to new one.
> Many thanks in advance.
> Regards,
> Chris Lee
|||Apologies - just assumed you were upgrading. Please refer
to Hari's post then.
Regards,
Paul Ibison
|||Thanks Hari,
It's work!!! Great Thanks!
Regards,
Chris Lee