Copy Database from MSSQL 7.0 to MSSQL 2000

[joannyk]

Dear All,

When I used 'Copy Database Wizard' to copy a database from SQL7.0 to SQL2000 platform, I got a message 'Your SQL Server is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network'. Can anyone tell me where to set this property?

Thanks in advance

 

[MaxZak]

You can set it using the Windows Services manager (in the server) and setting the properties for the MSSQLSERVER service, or right-clicking on the server name from the EM, select "Properties" and then the Security tab.

 

[JoeVegas]

Check database DETACH & ATTACH. When you DETACH a database it is removed from SQL Server but the .MDF and .LDF files are retained in MSSQL\DATA. Copy those files to the appropriate backup meduim, then/or go to the other SQL Server and in the respective SQL Group perform an database ATTACH.

 

[joannyk]

Thanks MaxZak and JoeVegas!

However, I couldn't find the 'Detach' function from the SQL7.0 server. I right clicked on the database name then click 'All Tasks' but no 'Detach' on the menu list. Where can I find this function?

Thx.

 

[MaxZak]

Try to detach using the stored procedure 'sp_detach_db' (look at BOL for help)