up vote 2 down vote favorite
share [g+] share [fb]

There's a machine running Win7; SQL Server 2000. (Suppose) Remote connections to the machine aren't possible. I need to copy a database from the machine to other one which is running SQL Server 2008 R2/2005;

How would I do that?

link|improve this question
Which protocols/ports are allowed? – Khaled Feb 2 at 9:40
feedback

1 Answer

up vote 2 down vote accepted
  • Backup/restore will help
  • If you have physical administrative access to the server - shut it down, copy DB files and attach
link|improve this answer
So there are no addtional upgrade-conversions between versions am I right? – helicera Feb 2 at 10:03
You may wamt to change the compatibility level of DB from 80 to 100. Thats all – Oleg Dok Feb 2 at 10:46
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.