June 5, 2006 at 9:52 pm
June 7, 2006 at 5:17 am
Hello,
First: I think it is a hard job to detach/attach master database 🙂
Second: it is a final 'no' in not beeing able to run the 2k version? 2k has a compatibility level that can be set to '70'.
Third: Regarding the move between sql7 and sql7, you may check this http://support.microsoft.com/kb/224071 and http://support.microsoft.com/kb/304692
...
N: I moved some time ago a 65 to 2k with only performance penalties (I used 'tempdb in ram' in 65 and a lot of intermediary #tables in procedures, so in 2k I had to use table variabiles). You should pay attention to logins and users and to security etc..
Success
E.I.
June 7, 2006 at 9:19 am
Hi,
Is both the servers on LAN (Local Area Network) if yes,then you can use the DTS Wizards to transfer all the Database and its all Objects into that server.
If No, Then Stop the Sql Sever Sevices.and copy all the *.MDF & *.LDF FILE and then attach it as mentioned in above comments....
Regards,
Amit Gupta........
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply